View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Curtis Curtis is offline
external usenet poster
 
Posts: 181
Default Sumproduct I think but a tough one

Source Sheet

D8:Q8 contains data -1 through 12 which represents months of the current
year (1 thru 12)and the 2 from the previous year (-1, and 0)

Range B10: b129 contains account numbers

Range d10:d129 contains costing data

Summary Sheet

Cell b3 will contain either -1 through 12 based on user request
Row J will contain the account # (j1 =100, J2=200, etc..)
The rest of the document requires no other intervention as it is preset with
values.


I need a formula that will lookup cell B3 and J6 in the summary sheet and
look to the source sheet and show me the costing

Hope that makes sense


Thanks alot