How Do I Implement Excel Filter Function Through Formula?
<p>I have a table of data, and some of the data is garbage. There's about 30000 entries sorted by unit. I only care about 20 of those units. I can easily sort the data by applying a filter, but it's tedious to click the 23 or so times and I'm going to have to manage this report weekly.</p>

<p>I've captured the relevant criteria into a different sheet, all non-repeating values sorted into a column. I'd like to arrange another sheet so that it only displays the rows from my table if the data in their unit column matches the criteria column.</p>

<p>I know I need to use VLOOKUP... somehow, but I haven't stumbled across any tutorials that compare a cell's value to a table.</p>

<p>In case that was all very confusing:</p>

<p>My table:</p>

<pre><code>Action | Job Desc    | Dept         
XFR    | IT Guy      | Home Office 1
POS    | Security Guy| Satellite Office
TTL    | Analyst Guy | Home Office 2
</code></pre>

<p>I want to have a new sheet that only contains 3 rows:</p>

<pre><code>Action | Job Desc    | Dept         
XFR    | IT Guy      | Home Office 1
TTL    | Analyst Guy | Home Office 2
</code></pre>

<p>I have the values "Home Office 1" and "Home Office 2" stored elsewhere (there are actually 28 different office values). How do I build this sheet so it only displays these values - similar to the stock Excel filter function?</p>