excel simple lookup help

Associate
Joined
18 Sep 2003
Posts
2,368
I have two columns and I want to work out what keywords from column B are contained within column A. How do I work this out? I think I've done this in the past using V lookup but have since lost the formula.

Any help is appreciated :)
 
Last edited:
thanks swinnie, but that method would only check one keyword in column B against one in column A. Whereas I need to check one keyword from B against all keywords in column A.
 
Something like:
Code:
=VLOOKUP(B2,E2:F6,2,FALSE)

Could you not use the wizard in Excel? Would have thought that would help you out a great deal. :)
 
If the keywords are embedded within other characters, you probably need to use a FIND formula. Try:

=IF(ISERROR(FIND("example",A1,1)=TRUE),"NOT FOUND",FIND("example",A1,1))

(It's case sensitive)

The "iserror" just stops you getting a "#VALUE" error if it can't find the search field.

PS - in your case you'd substitute the word "example" with the cell reference of the word you're trying to find.
 
Back
Top Bottom