Compare workbooks [Closed]

Registration date
Friday March 11, 2016
Last seen
March 11, 2016
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!