How to tackle multiple conditions (date range, destinations & type of load) with vlookup?

Hi,

I'm new to this forum and this is my first post. I'm stuck at vlookup and date range function and badly need your help.

I have attached a workbook wherein, in sheet 1, I want to bring from sheet 2 and 3 the "basic fare charged" for each of the destinations which keeps on varying. I have used date range function in L4 but don't know how to use vlookup or other function to link it up to different destinations (column D).

Thanks in advance.