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
.
|