find/search/exact??

[Tom G.]

I have a list of 6100 names in column A, and 10000 names
in column B. I'm trying to figure out how to use a
function to tell me if the name in Column B is present in
Column A. I tried using =EXACT(B1,A1:A6101) but the
fuction always returns FALSE even though the name in B1
exists in Column A. I tried the SEARCH function as well,
but am not having any luck with that either. Sort of a
EXCEL newbie as you can probably tell, so any help would
be appreciated. TIA!

 

[NH]

Use vlookup

 

[Guest]

Thanks for the reply, but I'm not having luck with
VLOOKUP.

I set up a test page and have 4 entries in Column A:
Apple, Banana, Grape, Orange

In B1, I have Grape and the formula VLOOKUP(B1,A1:A4,1)
returns Grape.

In B2, I have Tomato and using the same formula and
substituting B2 for B1, it returns Orange????

Perhaps I'm not using the formula correctly?

 

[Guest]

I figured it out, needed to include FALSE at the end of
the formula. THANKS!!