Searching for a date in date ranges and more

Ok, so a little precursor, I'm ok at excel just not that familiar with it. I am in Accounts payable and as part of my job I have to check on fuel surcharges which requires me to look at some tables in excel. My problem is they are separate. When trying to decide on a price you first search for a date which will give you the price of the gas. With that price you find the price in a certain range of prices which will give you the contract fuel price.

For example:

I want to find the fuel price for 09/25/12.

09/16/12 to 09/22/12 = 4.132 (DOE price) = 4.110-4.169 = 1.50
09/23/12 to 09/29/12 = 4.135 (DOE price) = 4.110-4.169 = 1.50
09/30/12 to 10/06/12 = 4.086 (DOE price) = 4.050-4.109 = 1.47

So if I search for 09/25/12 it falls in the 09/23/12 to 09/29/12 range which then tells me in the end that the contract price is 1.50.

There is no need to calculate the amounts because it is a set contract. The date ranges are constant and the first price is released by the DOE every week. So the table is always going to be the same except for the DOE price.


What I wish to do to save time, is to be able to search for a date and have the rest of the information appear or highlight. I am not even sure if this is possible in excel. I am also not sure if you all will need more information. Any help would be greatly appreciated, even if someone could give me a good starting point. Thank you!!!

Please help!