LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Lookup Ant Excel Discussion (Misc queries) 1 September 2nd 09 03:16 AM
Excel 2007 - Multiple If Then or Lookup SpecialK Excel Worksheet Functions 7 June 8th 09 04:55 AM
Sum Result of lookup in excel 2007 David Ryan Excel Worksheet Functions 5 April 1st 09 09:55 AM
Excel 2007 Lookup Trish Excel Worksheet Functions 4 July 23rd 08 06:29 AM
Excel 2007 LOOKUP Problem? robertbjr Excel Worksheet Functions 3 March 18th 08 06:32 PM


All times are GMT +1. The time now is 04:22 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"