View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LunaMoon LunaMoon is offline
external usenet poster
 
Posts: 97
Default 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!