Lookup and return from another table

[Tigerexcel]

Hi all,

I'd like to create a vlookup or index match formula to return the respective acceptances. In this case, Maths under Part 1 should return 7, Maths under Part 1A should return 2. Am stuck and would appreciate any assistance.

Mock data.xlsx
	A	B	C	D	E	F	G	H
1	Diploma	Part 1	Part 1A	Part 2
2	Maths					Diploma	Level	Total Acceptances
3	Maths(Education)					English	Part 1	8
4	English					English	Part 2	9
5						Maths	Part 1	7
6						Maths	Part 1A	2
7						Maths	Part 2	36
8						Maths(Education)	Part 1	0
9						Maths(Education)	Part 2	2
Sheet1

 

[mrshl9898]

B2, copied across and down

=SUMIFS($H:$H,$G:$G,B$1,$F:$F,$A2)

 

[Tigerexcel]

Thank you so much mrshl9898.
So I was on the wrong track trying to use a Lookup function, if anyone cares to chime in, can this be done via a combination of lookup, index and match?

 

[Fluff]

can this be done via a combination of lookup, index and match?

As long as there will only be one instance of each pair of values, then yes. But I would use the sumifs formula.