Lookup - in various areas within Workbook

C

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
 
L

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
 
S

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top