title: Copy multiple data columns with the same key from another sheet excel
body: <p>I want to copy multiple columns with the same key from one Excel sheet to another. </p>
  
  <p>Example:</p>
  
  <p><strong>Sheet 1</strong>:</p>
  
  <pre><code>123 | a | aa  
  123 | b | bb  
  123 | c | cc  
  234 | d | dd  
  234 | e | ee  
  55  | f | ff  
  123 | g | gg
  </code></pre>
  
  <p><strong>Sheet 2</strong>:</p>
  
  <p>One cell where I put my key; in this case <code>123</code>; and I want to have every column from sheet 1 shown on sheet 2, with key <code>123</code>.<br>
  So it has to look like this on sheet 2:  </p>
  
  <pre><code>Key:123
  
  automaticly shown:  
  123 | a | aa  
  123 | b | bb  
  123 | c | cc  
  123 | g | gg
  </code></pre>
  
  <p>I guess it is one of the easier things to do, but I am pretty new to Excel.<br>
  I do not want to use VBA code. I just want to use normal functions which you put in a cell, like <code>IF</code> etc.  </p>