Multiple text search/find

[PSSMITH]

Hi there, I have a list of text entries eg A1="this dog is a brown one", A2="why is my cat yellow?", A3="the red bird flew away".
I would like to search these entries to find a match with any one of the following list, D:D="red, blue, brown, black, yellow" and return the word that matches, eg B1="brown", B2="yellow", B3="red".
Is there a way to do this easily?
Cheers, Paul.

 

[Robert Mika]

Hi there, I have a list of text entries eg A1="this dog is a brown one", A2="why is my cat yellow?", A3="the red bird flew away".
I would like to search these entries to find a match with any one of the following list, D:D="red, blue, brown, black, yellow" and return the word that matches, eg B1="brown", B2="yellow", B3="red".
Is there a way to do this easily?
Cheers, Paul.

Hello and welcome:

Excel Workbook
	A	B	C	D
1	this dog is a brown one	brown
2	why is my cat yellow	yellow		red
3	the red bird flew away	red		blue
4				brown
5				black
6				yellow
Sheet2

 

[PSSMITH]

Thanks Robert ... worked a treat.

 

[Robert Mika]

Thanks Robert ... worked a treat.

You are welcome.

 

[Aladin Akyurek]

Hi there, I have a list of text entries eg A1="this dog is a brown one", A2="why is my cat yellow?", A3="the red bird flew away".
I would like to search these entries to find a match with any one of the following list, D:D="red, blue, brown, black, yellow" and return the word that matches, eg B1="brown", B2="yellow", B3="red".
Is there a way to do this easily?
Cheers, Paul.

Also...

Let KeywordList stand for the range housing the search items like, red, blue, etc, each in a cell of its own:

B1, just enter and copy down:

=LOOKUP(9.99999999999999E+307,SEARCH(" "&KeywordList&" "," "&A1&" "),KeywordList)