I am trying to use excel to pull data from 1 sheet to another based on if a student has paid an exam fee or not. Looking at the first sheet, I want G2 to determine if the student listed in A2 has paid for the exam listed in G1 by looking at the "Test Data" sheet. I had tried doing a INDEX, MATCH with multiple criteria but it didn't pull the correct result.

Here was my initial formula:
=INDEX('Test data'!A2:E986,MATCH(1,('Test data'!A1:A985='Student Reg & Exam Orders'!A2)*('Test data'!C1:C985='Student Reg & Exam Orders'!G1),0),5)

For G2, I want Excel to determine that A2 has paid for G1 and return the value of column E from the Test Data sheet for the corresponding row or leave it blank. So cell G2 should have a 1 but G3 should be blank because A3 hasn't paid for G1.

Help?!