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...
It looks like you have structured tables in two sheets
You may add to Master another column (Test) with formula in it like
=IF( ISNA(
XMATCH( [@Model]&[@Nomenclature]&[@Syscode]&[@Intvl],
TB43_180[Model]&TB43_180[Nomenclature]&TB43_180[Syscode]&TB43_180[Intvl]) ),
"not match", "" )and apply conditional formatting to highlight not matched records.
Similar could be done with ranges and MATCH().
SergeiBaklan Thanks, figured it out on my own but your solution is much more elegant!