Lookup - in various areas within Workbook

[CherylH]

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

 

[Lars-Åke Aspelin]

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

Try this formula:

=INDEX(Sheet1!B$1:B$100,MATCH(A1,Sheet1!E$1:E$100,0))

Hope this helps / Lars-Åke

 

[Shane Devenshire]

Hi,

You can use

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