title: Subset Excel rows based on column values using vlookup
body: <p>I have a workbook:</p>
  
  <pre><code>sheet1:
  id name ...(100 columns)
  1  a
  2  b
  3  c
  ...
  (about 300,000 rows)
  sheet2:
  id
  3
  4
  ...
  (about 50,000 rows)
  </code></pre>
  
  <p>I want to select rows in sheet1 with id in sheet2, I tried using vlookup in sheet2:</p>
  
  <pre><code>VLOOKUP($A2, sheet1!$A:$CV, 1)
  </code></pre>
  
  <p>the problem is that I have 100 columns, autofill the cell horizontally doesn't automatically add the last parameter in vlookup, i.e., I have to manually change it to 2,3,...,100. Is there any better way to do this?</p>