LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
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
Please help. This is way too tough for me. Champ Excel Discussion (Misc queries) 2 November 24th 08 02:58 PM
Tough one Ben Excel Discussion (Misc queries) 3 December 11th 06 05:13 PM
Tough one: Imba Excel Discussion (Misc queries) 7 November 15th 06 08:19 PM
Tough: Vlookup, Match, Sumproduct? To create list of persistence SteveC Excel Discussion (Misc queries) 1 June 5th 06 03:34 PM
Tough one... Peter1999 Excel Discussion (Misc queries) 4 May 2nd 06 11:18 AM


All times are GMT +1. The time now is 08:33 AM.

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

About Us

"It's about Microsoft Excel"