title: ARRAYFORMULA(VLOOKUP()) returning first lookup for all results
body: <p>I'm trying to use the following formula:</p>
  
  <p><code>=ARRAYFORMULA(VLOOKUP( $E2 &amp; $G2, { ARRAYFORMULA (SKUs!$A2:$A &amp; SKUs!$B2:$B ), SKUs!$D2:$D }, 2*SIGN(ROW($E2:$E)), FALSE))</code></p>
  
  <p>to retrieve SKUs from a separate sheet in the same document. However, my column is only returning the first value over and over again to fill the column.</p>
  
  <p>Current sheet:</p>
  
  <pre><code>   E              G             H (contains formula)
  chicken        sandwich        456
  duck           sandwich        456
  turkey         whole           456
  </code></pre>
  
  <p>SKUs:</p>
  
  <pre><code>   A              B             D
  chicken        sandwich        456
  duck           sandwich        789
  turkey         whole           123
  </code></pre>
  
  <p>I've tried changing nearly every individual piece of the formula that made sense, but it continues to just return the SKU of the first item when it looks it up. I did verify, however, that it is properly <code>VLOOKUP</code>ing the first item. (that's not the first item in the SKUs list).</p>
  
  <p>Anyone have any idea what I'm doing wrong here?</p>
  
  <p><sub>I posted this issue on Google Docs Help Forum as well</sub></p>