Offset function

[Ron99]

Hello,

I need a bit of help with Offset function. The below is the source data.

MONTH	TYPE	CLASS	%
JAN	PA	A	90
JAN	KR	A	100
JAN	SE	A	80
FEB	PA	A	70
FEB	KR	B	80
FEB	SE	C	65
MAR	PA	B	90
MAR	KR	A	80
MAR	SE	C	70
APR	PA	A	60
APR	KR	B	50

<tbody>
</tbody>

Below is the OUTPUT TABLE where I want the offset function to pick the % from the source data and put them across the blank cells.

	CLASS A	CLASS A	CLASS A	CLASS B	CLASS B	CLASS B	CLASS C	CLASS C	CLASS C
	JAN	FEB	MAR	JAN	FEB	MAR	JAN	FEB	MAR
PA
KR
SE

<tbody>
</tbody>

Thanks,
Ron..

 

[Eric W]

With that layout, I'd suggest SUMIFS:

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	MONTH	TYPE	CLASS	%				CLASS A	CLASS A	CLASS A	CLASS B	CLASS B	CLASS B	CLASS C	CLASS C	CLASS C
2	JAN	PA	A	90				JAN	FEB	MAR	JAN	FEB	MAR	JAN	FEB	MAR
3	JAN	KR	A	100			PA	90	70	0	0	0	90	0	0	0
4	JAN	SE	A	80			KR	100	0	80	0	80	0	0	0	0
5	FEB	PA	A	70			SE	80	0	0	0	0	0	0	65	70
6	FEB	KR	B	80
7	FEB	SE	C	65
8	MAR	PA	B	90
9	MAR	KR	A	80
10	MAR	SE	C	70
11	APR	PA	A	60
12	APR	KR	B	50

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula H3 =SUMIFS($D$2:$D$12,$A$2:$A$12,H$2,$B$2:$B$12,$G3,$C$2:$C$12,RIGHT(H$1)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>