Formula to Look for value then for latest date then show value in third column

Hi Exlcel Forum,

I have 2 sheets one with a overall table and one with an individual.
I am trying to make the table on the first sheet extract information from the second.
On the table on the second sheet i have a exam title column, a exam date column and a grade column

I need a formula (maybe an index match formula) that look in the first column for a specific word and then looks for the most recent date and then returns the result in the final column.

I have been messing around but have not managed to figure it out yet.
I have attached a sample workbook as this will probably help with my rubbish explaining! haha

Thanks

Jamidd