Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to print a workbook but worksheets have diff print areas | Excel Discussion (Misc queries) | |||
lookup value from different workbook | Excel Discussion (Misc queries) | |||
lookup in 1 workbook to get data for another workbook | Excel Worksheet Functions | |||
Excel lookup in multiple areas | Excel Worksheet Functions | |||
Cannot Format areas of a workbook | Excel Discussion (Misc queries) |