Formula needed - looking up values

[Jeff]

I have two colums. I need to find if the text or items in
one column are located in any cells in the other column.

Any one?

 

[Aladin Akyurek]

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

1 means yes, 0 no.