Lookup - in various areas within Workbook
 

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

Lookup - in various areas within Workbook
 

On Wed, 31 Dec 2008 07:15:01 -0800, 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

Try this formula:

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

Hope this helps / Lars-Åke

Lookup - in various areas within Workbook
 

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