Merge Purge
 

I have two separate spreadsheets of data both have an ID# attached to each
row of data which I need to match.

The first spreadsheet has lots of data of information and these ID#s may or
may not repeat depending on how many products one ID may have.

The second spreadsheet has all the ID#s which I need to review. I'd like to
remove any identifying numbers from the first spreadsheet that do not appear
on the second spreadsheet and only keep the matching ID#s.

How can I do this?

Thank you!