Find value in range with two criterias, INDEX MATCH MAX

Hi guys,

I am struggling with a INDEX,MATCH and MAX formula. I am trying to retrive values from column E with two criterias:
1. That the value in column C is equal to a lookup value
2. That the date in column A is the closest before date for a lookup date

I have attatched an example file that hopefully will explain better.

I would really appreciate all help

Gnoke