Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SOS! how do I do multiple-value lookup in Excel 2007?
I have two regions in exact same places of sheet 1 and sheet 2,
I want to find all cells in the region in sheet 1, such that the cell content equal to 0, and then add the numbers at the corresponding locations in the region in sheet 2 up. For example, let's say in the region in sheet 1, there are multiple locations where the cell content = 0: A1, B3, C4, D2, etc... I would like to obtain sum(sheet2!A1, sheet2!B3, sheet2!C4, sheet2! D2), etc. How do I do that? Thanks a lot! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Lookup | Excel Discussion (Misc queries) | |||
Excel 2007 - Multiple If Then or Lookup | Excel Worksheet Functions | |||
Sum Result of lookup in excel 2007 | Excel Worksheet Functions | |||
Excel 2007 Lookup | Excel Worksheet Functions | |||
Excel 2007 LOOKUP Problem? | Excel Worksheet Functions |