title: vlookup with multiple columns
body: <p>I have the following formula in my B:B column</p>
  
  <pre><code>=VLOOKUP(A1;'mySheet'!$A:$B;2;FALSE)
  </code></pre>
  
  <p>It does output in B:B the values found in the mySheet!B:B where A:A = mySheet!A:A. It works fine. Now, I would like to also get the third column. It works if I add the following formula to the whole C:C column:</p>
  
  <pre><code>=VLOOKUP(A1;'mySheet'!$A:$C;3;FALSE)
  </code></pre>
  
  <p>However, I'm working with more than 100k lines and about 40 columns. I don't want to do 100k * 40 * VLOOKUP, I would like to only do it 100k and not have to multiply this by all the columns. Is there a way (with array-formulas maybe) to just do the VLOOKUP once per line to get all the columns I need?</p>
  
  <hr>
  
  <p><strong>data example</strong></p>
  
  <pre><code>ID|Name
  -------
   1|AB
   2|CB
   3|DF
   4|EF
  
  ID|Column 1|Column 2
  --------------------
   1|somedata|whatever1
   4|somedate|whatever2
   3|somedaty|whatever3
  </code></pre>
  
  <p>I would like to get:</p>
  
  <pre><code>ID|Name|Column 1|Column 2
  -------------------------
   1|AB  |somedata|whatever1
   2|CB  |        |
   3|DF  |somedaty|whatever2
   4|EF  |somedate|whatever3
  </code></pre>