Looking up multiple variables in a table and giving the results

I am trying to put together a discount calculator. There are 3 variables: Pricing Type, Partner Type and Discount level. Each one of these has several options

Pricing Type: Base, Incumbent, DR sub 1,000, DR over 1,000
Partner Type: R, S, G, P
Discount Level:
1-24%
25%-34%
35%-44%
45%-64%
65%-84%

What I would like to do is have drop down boxes for each of the above (I can do that bit in attached spread sheet) and then from that calculate the correct discount base on the three variables. e.g. Base, R, 1-24% would then give me the correct discount from a table.

I have attached a spread sheet - disc calc.xlsx - with the relevant information would be grateful if some one could show me how to do it?


Many Thanks