Match

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Column A houses a series of number.
Column C does too.
Not finding quickly the correct formula to test if cell A1 has any matching
column C.

Thanks,
Arturo
 
Try this:-

=IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),"No match","Match Found")

Mike
 
in D1:

=IF(Countif(A:A,C1),"Yes","") wll give "Yes" if a match

and copy down
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding matches in two columns 4
Matching function or no match 3
With F1 value, look at A, if match or partial match return B 5
match formula 2
What is the "--" (double dash) in MS Excel formula? 2
matching columns to find differences. 0
summing part of a string, excluding cells 1
worksheet function... 6

Back
Top