INDEX MATCH to seek the latest information

[sampahmel]

Hi all,

I am presented with a problem as detailed in the attached excel file.

My question is as follow:

When given only 2 pieces of information, which are ID and Subject, how do I go about to retrieve the LATEST score?
Take John for example. His Math score is listed twice on 2 different dates. What formula can I come to rely to retrieve the 99% score for Math on 3/1/2015?

Tried Index Match combo but wasn't able to figure out how to get the LATEST score?

Thanks.