matching numbers

[mypig7]

I have 2 columns of numbers.

What formula can I use to tell me "yes" if a number that appears in the 1st column (column A) also appears somewhere in the second column (column B).

If it doesn't appear, I want "no" to appear.
The numbers aren't necessarily on the same line if they are in both tables.

Thanks

 

[Von Pookie]

Try

=IF(COUNTIF($B:$B,$A1)>=1,"Yes","No")

 

[Aladin Akyurek]

Try

=IF(COUNTIF($B:$B,$A1)>=1,"Yes","No")

=ISNUMBER(MATCH($A1,$B:$B,0))

is faster.

 

[mypig7]

many thanks