Multiple Criteria for results with dates and numbers

[dwinsburg]

I am trying to find the right formula to be created to work in a function of finding a date range and spitting out a dollar value associated with that date range.. For Example I am trying to create a travel estimator by picking the location of the trip and then based on the estimated month of the trip to look in the attached GSA location area and spitting out the correct Per diem rates for hotel and meals.