Sumproduct , Index & Match

[uswyne]

GR#	Name	Head	Amount
12	Usman	Security	25000
12	Usman	Admission	25000
12	Usman	Tution Fee Aug	17000
13	Ali	Security	25000
13	Ali	Admission	25000
13	Ali	Tution Fee Aug	17000
14	Omar	Tution Fee	17000

<tbody>
</tbody>

GR #	Name	Security	Admission	Aug	Sep
12	Usman	25000	25000	17000
13
14

<tbody>
</tbody>

I want to fetch data by entering GR #. Kindly help me

 

[SyedUsman]

	A	B	C	D
1	GR#	Name	head	Amount
2	12	USMAN	SECURTIY	25000
3	12	USMAN	ADMISSION	25000
4	12	USMAN	TUTION FEE AUG	17000
5	13	ALI	SECURTIY	25000
6	13	ALI	ADMISSION	25000
7	13	ALI	TUTION FEE AUG	17000
8	14	OMAR	TUTION FEE AUG	17000

<tbody>
</tbody>

11	A	B	C	D	E	F
12	R#	NAME	SECURITY	ADMISSION	AUG	SEP
13	12	=INDEX(B2:B8,MATCH(A13,A2:A8,0))	=SUMIFS($D$2:$D$8,$B$2:$B$8,$B13,$C$2:$C$8,C$12)	DRAG LEFT	=SUMIFS($D$2:$D$8,$B$2:$B$8,$B13,$C$2:$C$8,"*"&E$12&"*")	DRAG LEFT
14	13	DRAG DOWN	DRAG DOWN	DRAG LEFT	DRAG DOWN	DRAG LEFT
15	14	DRAG DOWN	DRAG DOWN	DRAG LEFT	DRAG DOWN	DRAG LEFT

<tbody>
</tbody>

 

[uswyne]

Thank you so much