Forum Discussion
Comparing Two Worksheets, please help!
I have two worksheets in a workbook, 'Master' and 'TB43-180'. I need something that will check each line in the Master against each line in TB43-180, such that if the model, nomenclature, and...
surefirewizard Perhaps the easiest method to follow would be to add a column to each table where you concatenate the four relevant columns. Then in the second table, add yet another column where you VLOOKUP (or XLOOKUP if your Excel version supports it) the concatenated values from Table2 in the added column in Table1. Anything other than #NA means that a matching value was found. #NA is thus equivalent to FALSE in your example.
But, if these are very large tables and you have to this on a regular basis, I would use Power Query.