Help looking up a value based on a date and 2 other conditions

[Mateja011]

Hello everyone,

i hate having to bother anyone with this, but i just cant find a solution to this problem. Would really appreciate some help.

what im trying to do is from a large database of employee contract elements changes, take info on what % of annual bonus was relevent on each month of 2014. As well as take info on the value of base salary that was valid for each month.

On top of that, to manually calculate for persons whose data changed during 2014 (in the middle of month his bonus increased for example), i would also need the dates on which the change occured.

In the example attached, there is example database in rows A3:F12
There are 2 persons, with 2 unique IDs. There are listed two types of compensations/benefits (annual bonus, and base salary). Each entry, or change of those elements has a specific date.

I would like to have a formula populate fields on the right side, marked yellow. Can someone please help me out.
I have manually given the type of result im looking for.

Ty for any kind of help you can give!
Mateja