Match

[Arturo]

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

 

[Mike H]

Try this:-

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

Mike

 

[Toppers]

in D1:

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

and copy down

 

[Teethless mama]

=IF(COUNTIF(C:C,A1),"found","not found")