Compare workbooks

mikeshog Posts 1 Registration date Friday March 11, 2016 Status Member Last seen March 11, 2016 - Mar 11, 2016 at 09:38 AM
I have a two column workbook. Column 1 is a part number and column 2 is a description.

I generate a second workbook with hundreds of numbers and up to 30 columns.
The first 2 rows are part numbers and description.

Is there a way to compare the part number column rows and indicate where they match.

I need to flag the numbers on the second workbook that are also on the first workbook. Ideal would be to indicate in a separate row that there is a match.