If the date doesn't match exactly, pick the value from just earlier date

I want to pick the amount in a particular date. If the date doesn't match exactly it will pick the amount from the just earlier date.
Conditio: match id and date

Hi Arif,

Please check the attached file. I have apply the formulas according to your condition: match id & date.
Can you please check the output that you have given manually.

Regards,
AM

Hi AM,

Where is the attachment?????

Regards
Nisha

Here you go!

Please can you explain the formulae ?

Sorry. My mistake.
I want to pick the amount in a particular date (i.e. 5 March 2014). If the date doesn't match exactly it will pick the amount from the previous date (just previous smaller date of 5 March 2014). For example if the date series are 25 Jan 2014, 25 Feb 2014, 25 Mar 2014 and 25 Apr 2014 then it will show the value of 25 February 2014.
Regards
Arif

Any solution? Please help.
[I want to pick the amount in a particular date (i.e. 5 March 2014). If the date doesn't match exactly it will pick the amount from the previous date (just previous smaller date of 5 March 2014). For example if the date series are 25 Jan 2014, 25 Feb 2014, 25 Mar 2014 and 25 Apr 2014 then it will show the value of 25 February 2014.]

Dear Bebo02199 & Maitrayk
Thanks for the solution. I am impressed and really grateful to you both.
It is exactly what I wanted.
Bebo mistakenly I wrote B1, B2, B3, B4. actuality all ID will be B1. Same for C.

You are genius. Thanks again.

Arif