Multiple conditions to get data

Hello,

I need a formula to get data based on 2 conditions. One condition is date and another is a lookup value. I have attached a spreadsheet with my requirement. Can you please look into it and advise how can I get the required data.

Regards,
Mandeep