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

"Teethless mama" wrote:

Assuming one color for each fruit.

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

copy down


"Kim" wrote:

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!