I've searched on the board, but probably not using the right terms.
I have a list of part numbers from Column A - H and rows 1 - 452 that are on sheet 1 of the workbook.
I have been given a new list of part numbers that are columns A - C and rows 1-197 that I've copied into sheet 2 of the same workbook.
All I need to know is if any of the part numbers on Sheet 2 are already listed on Sheet 1.
Currently, I have a VLookup that references Column A of sheet 2, and compares to each individual Column of Sheet 1, so it takes 8 columns to complete the comparison. Then, I have 8 more columns to search for Column B and 8 more to search for Column C.
It is effective, inasmuch as it finds what I'm looking for.
It just seems like there ought to be a better way.
Any advice appreciated.
I have a list of part numbers from Column A - H and rows 1 - 452 that are on sheet 1 of the workbook.
I have been given a new list of part numbers that are columns A - C and rows 1-197 that I've copied into sheet 2 of the same workbook.
All I need to know is if any of the part numbers on Sheet 2 are already listed on Sheet 1.
Currently, I have a VLookup that references Column A of sheet 2, and compares to each individual Column of Sheet 1, so it takes 8 columns to complete the comparison. Then, I have 8 more columns to search for Column B and 8 more to search for Column C.
It is effective, inasmuch as it finds what I'm looking for.
It just seems like there ought to be a better way.
Any advice appreciated.