Formula Help (IF? DSUM? LOOKUP?)

[garymu16]

Book2
	A	B	C	D	E	F	G	H	I	J	K
1	Table			APR
2		Sales	Month	YTD
3		ProductA	1	4
4		ProductB	2	8
5		ProductC	3	12
6
7	Data		Month					Cumulative
8			Jan-06	Feb-06	Mar-06	Apr-06		Jan-06	Feb-06	Mar-06	Apr-06
9		ProductA	1	1	1	1		1	2	3	4
10		ProductB	2	2	2	2		2	4	6	8
11		ProductC	3	3	3	3		3	6	9	12
Sheet1

I am trying to set up a spreadsheet which will read, in this example, cell D1, lookup the product name and return the values for the appropriate month & YTD, based on the data entry tables.

Can anyone help out?

P.S. Cell D1 should read Apr-06 not APR as in my example - Apologies

 

[garymu16]

Thanks for the help Lenze

 

[acw]

Hi

C3: =SUMPRODUCT(--($B$9:$B$11=$B3),(OFFSET($B$9:$B$11,0,MATCH($D$1,$C$8:$F$8,0))))
D3: =SUMPRODUCT(--($B$9:$B$11=$B3),(OFFSET($G$9:$G$11,0,MATCH($D$1,$H$8:$K$8,0))))

HTH

Tony