Hi,

You can use

=LOOKUP(G1,Sheet2!E1:E9,Sheet2!B1:B9)
or
=INDEX(Sheet2!B1:B9,MATCH(G1,Sheet2!E1:E9,0))


--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"CherylH" wrote:

I need to do the following:
(1) Lookup the values in Worksheet #1, Column G,
(2) FIND the SAME value in Worksheet #2, Column E
(3) RETURN the Value from Worksheet #2, Column B (on the same row where the
lookup value was found in Worksheet #2, Column E


Worksheet #1, Column G
Apples

Worksheet #2
Col B Column E
ABC Apples

I want to see the value of "ABC", which corresponds to my value that was
within Column E.

Any help would surely be appreciated! Thanks all and Happy New Year!
Cheryl