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
On Sheet 2 Cell C2 Put this formula and drag down as required
=A2&B2
Then on Sheet1 Cell D2, put this one and drag down as required
=IF(ISNUMBER(MATCH(B2&C2,Sheet2!C:C,0)),"OK","")
Cheers!
Deep Dave
This question has been asked a zillion times, on the forum as well as on the Web. Perhaps try the forum's search tool
Deep Dave, thanks for your solution. Simple and effective, even I can understand it.
Pepe, I did search the Forum but couldn't narrow down the posts enough to answer my query. I am not a fool, although obviously not in your exalted league, but I do object to being patronised. If you have a positive comment to make, please make it. If your contribution is only to criticise, I would suggest keeping your thoughts to yourself.
Hi,
Glad I could help..
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks