<div>
I ended up using VLOOKUP, but thanks for the sugestion.
</div>


I ended up using VLOOKUP, but thanks for the sugestion.

<div>
<div class="content wysiwyg-content">
I have two sheets in an Excel document. <br />
<br />
Tab 1 - has pricing history for all items in inventory<br />
<br />
Tab 2 - has a list of items that were updated in the last 24 hours<br />
<br />
I'm looking to filder tab 1 to only show items that exist on tab 2. How can I do that in Excel?
</div>
</div>


I have two sheets in an Excel document. 

Tab 1 - has pricing history for all items in inventory

Tab 2 - has a list of items that were updated in the last 24 hours

I'm looking to filder tab 1 to only show items that exist on tab 2. How can I do that in Excel?

Excel 2010 help with lookup

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.