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!