| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct I think but a tough one
Yes
Sorry and Thanks "T. Valko" wrote: Range d10:d129 contains costing data Is that supposed to be: Range D10:Q129 contains costing data -- Biff Microsoft Excel MVP "Curtis" wrote in message ... 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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help. This is way too tough for me. | Excel Discussion (Misc queries) | |||
| Tough one | Excel Discussion (Misc queries) | |||
| Tough one: | Excel Discussion (Misc queries) | |||
| Tough: Vlookup, Match, Sumproduct? To create list of persistence | Excel Discussion (Misc queries) | |||
| Tough one... | Excel Discussion (Misc queries) | |||
Threaded Mode
