Lookup a cell based on 2 criteria

[shane24]

Good day everyone. I have a spreadsheet that is used for configuring the price of an item I am selling/leasing based on the price of the item. I have attached a sample so I don't have to explain everything in detail. It may take a while.

Basically, the cells B3, D2 & E2 are drop down lists that refer to the lease rate chart to use and the months or length of the lease. What I need is to select a chart from the list in B3. Then based on the selection in either D2 or E2 have D3 and E3 display the correct lease rate from the chart that corresponds to the month selected. The caviot is that the lease rate is based upon the total selling price. So we need to include that in the equation.

If any of you could please take a look at the sample I have posted and send me a message with any questions and help would truly appreciated.

Thanks,
Shane