Index/Match Array issue

Hi   I am trying to return a value based on multiple criteria using the index match function, but one of the criteria will need to return the latest date.   The data is as below. I want to return...