cross referancing

[Chris the man form socail services]

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

 

[Frank Kabel]

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