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.
 
Back
Top Bottom