Extract info from one sheet to another

[Kim]

I am trying to pull data from worksheet to another. I would like to search
for text found in one sheet and return a relative value from a different
column . Here is an example
Worksheet 1 contains a coumn of values:
apple
orange
banana

Worksheet 2 contains two columns:
apples (red delicious) red
apples (granny) red
oranges (florida) orange
banana yellow

In Worksheet 1... If the string apple is found anywhere in Worksheet 2,
column 1, I would like it to return the color from Worksheet 2, column 2 and
place it column 2 of Worksheet 1.

Any suggestions? Thanks!

 

[Teethless mama]

Assuming one color for each fruit.

=VLOOKUP(A2&"*",Sheet2!$A$2:$B$5,2,0)

copy down

 

[Kim]

Thank you! This saved me so many hours of work!
Kim