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.
