I'm sure this is easy but I can't get my head around it.
I need to compare 2 spreadsheets to identify if the same data is on each sheet.
See attached file. If the number (Column B) and type (COLUMN C) in sheet 1 is anywhere on sheet 2 (columns A and B, in the same combination) insert ‘OK’ in column D on sheet 1. Both sheets could have hundreds of rows.
I need a formula, rather than VBA/Macro.
Thanks in advance
Bookmarks