index match

[uswyne]

[TABLE="width: 500"]
<tbody>[TR]
[TD]GRN[/TD]
[TD]name[/TD]
[TD]Tuition Fee[/TD]
[TD]Computer Fee[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]AAAA[/TD]
[TD]11000[/TD]
[TD]1000[/TD]
[/TR]
[TR]
[TD]30[/TD]
[TD]BBBB[/TD]
[TD]10000[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]31[/TD]
[TD]CCC[/TD]
[TD]10000[/TD]
[TD]1000[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 500"]
<tbody>[TR]
[TD]Head[/TD]
[TD]GRN[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tuition Fee[/TD]
[TD]25[/TD]
[TD]11000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Computer Fee[/TD]
[TD]25[/TD]
[TD]1000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tuition Fee[/TD]
[TD]30[/TD]
[TD]10000[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tuition Fee (manually) [/TD]
[TD]31 (manually) [/TD]
[TD]? (Automatecally)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

What I want is that I select the head (A Column) and enter GRN (B Column) the amount automatically appear in (C column)

 

[FormR]

Hi, maybe something like this..:

Excel 2013/2016
	A	B	C	D	E	F	G	H
1	GRN	name	Tuition Fee	Computer Fee		Head	GRN	Amount
2	25	AAAA	11000	1000		Tuition Fee	25	11000
3	30	BBBB	10000			Computer Fee	25	1000
4	31	CCC	10000	1000		Tuition Fee	30	10000
5						Tuition Fee	31	10000
Sheet1

Cell Formulas
Range	Formula
H2	=INDEX($C$2:$D$4,MATCH(G2,$A$2:$A$4,0),MATCH(F2,$C$1:$D$1,0))