Hi
=IF(COUNTIF(B:B,A1),"Match","no match")


--
Regards
Frank Kabel
Frankfurt, Germany


Chris the man form socail services wrote:
if I have two columns on numbers how can I see if any numbers in
column a matches the number in column b preferably in the quickest
possible way. I already have been using the find option now Im
looking for a quicker way. please help!!