View Full Version : Match function for 2 columns
joelle
10-26-2009, 01:09 PM
Dear Gurus,
I am rushing .. so any quick help is so much appreciated.
Please how do I match the numbers from 2 cols, and it returns "N/A" for any un-match numbers. Many thanks. I attach a simple spreadsheet.
joelle
...Please how do I match the numbers from 2 cols, and it returns "N/A" for any un-match numbers. Many thanks. I attach a simple spreadsheet.
joelle
Greetings Joelle,
For a simple formula check, try:
=IF(B2<>C2,"N/A","Matches")
...in D2 and drag down.
Does that do what you want?
Mark
joelle
10-26-2009, 01:33 PM
Hello Mark,
The matching numbers are in random rows.
So B2 does not match C2, but value in C2 can be in C4.
I would like to know which ones in col C don't match any value in Col B.
Please help. Thanks.
joelle
Okay, I'm not sure what you want to return for the ones that a match is found for, but just to check each each cell (in col c) against the array of cells in Col B, MATCH would work.
Try:
=MATCH(C2,$B$2:$B$10,0)
...in D2 and drag down.
Is that any closer to what we're wanting?
Mark
mdmackillop
10-26-2009, 04:57 PM
or maybe
=COUNTIF(B:B,C2)
parttime_guy
10-26-2009, 11:53 PM
Apologies Big Guru's of vba - n sorry for butting in
But... I tried this the old fashioned way using ISRROR & VLOOKUP
Hope this method helps joelle....
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.