Match function for 2 columns

[joelle]

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]

...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]

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]

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]

or maybe
=COUNTIF(B:B,C2)

[parttime_guy]

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....