Match
Try this:-
=IF(ISNA(VLOOKUP(A1,C:C,1,FALSE)),"No match","Match Found")
Mike
"Arturo" wrote:
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
|