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

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

thanx timiop.
seems after a good night sleep i managed to find a functional solution. Will upload the working example in case someone else has a simmilar problem.

Basically i just used a index, match functions, and nested a few if conditions inside match function. Nothing too crazy, but the down side is that excel (at least on my machine) takes a lot of time to process these formulas. Even more so if i transfer this to a 2000 row database

anyway, thanx for help, and hope someone funds this usefull.

cheers,
Mateja