Searching String Text for several if-than responses

[Underdog12]

Hi Everyone,

I keep messing this up and I'm sure its a simple mistake,,,,

I want to be able to search column d and have the response in column e

If d2 contains Strawberries, then Strawberries, if it contains Boat, then Boat, if Turkey, then Turkey -

ID	Location	Region	Description
1	Florida	3	Bananas Strawberries Cars Fox Pineapple
2	Texas	2	Red Blue Stars Stripes Car Boat
3	Florida	9	Boat Blue Red Car Pineapple
4	New York	12	Turkey Cookie Grapes Florida
5	California	53	Strawberries Goat Frog
6	Texas	4	Car Boat Red Blue
7	New York	13	Green Purple Jet Turkey

Thank you in advance

 

[Underdog12]

Hi Everyone,

I keep messing this up and I'm sure its a simple mistake,,,,

I want to be able to search column d and have the response in column e

If d2 contains Strawberries, then Strawberries, if it contains Boat, then Boat, if Turkey, then Turkey -

ID	Location	Region	Description
1	Florida	3	Bananas Strawberries Cars Fox Pineapple
2	Texas	2	Red Blue Stars Stripes Car Boat
3	Florida	9	Boat Blue Red Car Pineapple
4	New York	12	Turkey Cookie Grapes Florida
5	California	53	Strawberries Goat Frog
6	Texas	4	Car Boat Red Blue
7	New York	13	Green Purple Jet Turkey

Thank you in advance

Sorry - I forgot to say that I want the search to be done row by row - not as a whole.

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

What happens if a cell contains 2 or more of the "words of interest"? Or is that not possible with your data?