On Monday, March 18, 2013 8:37:58 AM UTC-7, otteraaron wrote:
Hello,



First, I apologize if this has been answered already. I did some

searching and had no luck finding a solution.



Here's what I'm looking to do: I have a long list of text strings, and

i'm looking to identify certain keywords, and report back those

keywords.



EXAMPLE:

Column A is full of product descriptions:



Black Otterbox Case for iPhone

Blue Speck case for iphone

Pink Otterbox case for GS3

White Case Mate case for iphone 5

Blue Otterbox case for iphone 4s



Column B are the "brands" i'm searching for:

OtterBox

Case Mate

Speck



I would like to have a formula that searches for words in Column B

located in Column A, then report back that word.



Example, if A1 was "Black Otterbox case for iPhone", i would want the

result in column c to read "OtterBox"



Make sense? Thanks in advance for any help you can provide!!









--

otteraaron

Give this a try where E10 holds the word OTTERBOX or SPECK etc.
And the list of stuff you are searching begins in A12.
Pull the formula down.
Change the lookup word in E10 to suit.

=IF(SUMPRODUCT(1*NOT(ISERROR(FIND($E$10,A12))))=1, $E$10,"")

Regards,
Howard

PS: This is a modified version of a formula from my archives that I use in a home built project, and if my life dependened on it, I could not tell why it or how it works.