A simple formula like this will tell you if a match has occurred and in what row it is...

=Match(A1,B:B,0)

So this will check if the item in A1 is found anywhere in column B. If yes, it will display the position (in this case, also the row number) that it is found in. If there is no match you will simply get a #N/A error.

P.S. your original title did not correspond to the question you have.. so I changed it.