Extract info from one sheet to another

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!

Teethlessmama
Fri Mar 14 22:34:01 CDT 2008

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!

Kim
Sat Mar 15 08:30:01 CDT 2008

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!