PDA

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

GTO
10-26-2009, 01:19 PM
...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

GTO
10-26-2009, 04:38 PM
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....