title: How to filter an Excel table based on values in a column shard with another table?
body: <p>To start, I don't think <code>VLOOKUP</code> will work for me because I have dozens of columns in each table.</p>
  
  <p>Let's say I have Table 1:</p>
  
  <p><code>Serial#   Value1   Value2   Value3   Value4
   1         4        34       65       23
   2         123      43       54       46
   3         87       98       85       34
   4         654      8        645      3</code></p>
  
  <p>And Table 2:</p>
  
  <p><code>SF
   1
   3
   4</code></p>
  
  <p>I would like a way to filter Table 1 based on the serial numbers found in SF.</p>
  
  <p><code>Serial#   Value1   Value2   Value3   Value4
   1         4        34       65       23
   3         87       98       85       34
   4         654      8        645      3</code></p>
  
  <p>Using a <code>VLOOKUP</code> would mean I have to write a formula for every column I want filled. i'd like to avoid that.</p>
  
  <p>Thanks</p>