Lookup text string in cell, then return a corresponding value from another worksheet

[CF64]

Hello,
I have 2 worksheets.
Worksheet 1 contains a column of cells which contains multiple strings of text
Worksheet 2 contains a table with 2 columns. Column 1 contains text which matches what appears in Column A of Worksheet 1, and Column 2 contains some other text

What I am hoping someone can help me with is a formula to insert in Worksheet 1 - Column B, which will reference the cells in Worksheet 2 Column 1, and return the value in column 2
if cell in worksheet 1 column A contains "Apple", return "red" (from column 2 in worksheet 2) in column B of worksheet 1
if cell in worksheet 1 column A contains "Orange", return "navel" (from column 2 in worksheet 2) in column B of worksheet 1
if cell in worksheet 1 column A contains "banana", return "yellow" (from column 2 in worksheet 2) in column B of worksheet 1
etc.

Worksheet 1
A	B
apple orange bannana grapes strawberry
blueberry orange banana grapes strawberry
blueberry apple banana grapes strawberry

Worksheet 2
1	2
apple	red
orange	navel
bannana	yellow
grapes	green
strawberry	white

Any guidance is greatly appreciated
Thank you

 

[CF64]

Hi, I just realized an error in my table examples. The cell in worksheet 1 column A would only contain 1 of the values in the table in Worksheet 2 Column 1.

if cell in worksheet 1 column A contains "Apple", return "red" (from column 2 in worksheet 2) in column B of worksheet 1
if cell in worksheet 1 column A contains "cherry", return "tart" (from column 2 in worksheet 2) in column B of worksheet 1
if cell in worksheet 1 column A contains "kiwi", return "ripe" (from column 2 in worksheet 2) in column B of worksheet 1
if cell in worksheet 1 column A doesn't contain any of the values in Worksheet 2 column 1, return blank in column b of worksheet 1

Worksheet 1
A	B
apple orange bannana grapes strawberry
blueberry orange bannana grapes strawberry
blueberry cherry bannana grapes strawberry

Worksheet 2
1	2
apple	red
cherry	tart
rasberry	sweet
kiwi	ripe

Apologies for any confusion.