Multiple lookup based on date range pricing

Hi,

I want to find out price of particular material appicable as on its shipping date. I am having price list of the material prices which are range bound. Please help me to get the price as on shipping date based on attached sheet.

Thanks in Advance.