find text withing a string

[pankajchopra]

I would appreciate if someone could help.
I am trying to do something like this. Basically I am trying to search if there is any match from one table ( entire array ) into another array ( unstructured data) and categorize them in one or more of the categories

My data set in different rows

I HAVE A DOG
I HAVE A PIG
I HAVE A CAT
I HAVE A DOG AND CAT


My lookup table

MY DOG
MY CAT
PIG


I want the results like this:

1st column 2nd column

I HAVE A DOG MY DOG
I HAVE A PIG PIG
I HAVE A CAT CAT
I HAVE A DOG AND CAT MY DOG
I HAVE A DOG AND CAT MY CAT


The last row should be duplicated because it belongs to both categories so that later I can make a pivot table out of it

 

[IRstuff]

Student posting is not allowed.

TTFN
faq731-376

Need help writing a question or understanding a reply? forum1529