Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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) |