VBA for 2 Criterias

Hi,
I am new to Excel VBA.TestResults.xlsm
I have this following table.

Student Name	Subject	Mark	Grade
A	Eng	60	I
A	Sci	85	I
B	Eng	90	I
B	Maths	95	I

and so on...
I want a VBA for getting the marks for 2 criteria.
Say Name is A and Subject is Eng.
I have used index match inside excel cells...But now I require it to calculate programmatically.
Can anyone help.

Hi,

Can somebody look at the error in this file.

I am close to output.

Regards,
AM

Hi devpp,

Please check the attached file.

Regards,
AM