Tired Sale quantities with discounts by level

[Roar]

I am trying to create one cell that shows the discount approval level required which varies by quantity. Thank you for your patience.

So here is the matrix of what discount can be given at what quantity. The only require is to output a cell showing discount, which will then be conditionally formatted to alert the person they can approve or need to escalate. The quantity cell will be elsewhere. See below

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[/TR]
[TR]
[TD]Low Qty[/TD]
[TD]High Qty[/TD]
[TD]Discount 1[/TD]
[TD]Discount 2[/TD]
[TD]Discount 3[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]24[/TD]
[TD]0[/TD]
[TD]5[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]34[/TD]
[TD]5[/TD]
[TD]10[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]35[/TD]
[TD]54[/TD]
[TD]10[/TD]
[TD]15[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD]199[/TD]
[TD]15[/TD]
[TD]20[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]200
[/TD]
[TD][/TD]
[TD]20[/TD]
[TD]25[/TD]
[TD]30[/TD]
[/TR]
</tbody>[/TABLE]

SO, the sheet they are working on will look like this
[TABLE="width: 500"]
<tbody>[TR]
[TD]R[/TD]
[TD]S[/TD]
[TD]T[/TD]
[TD]U[/TD]
[TD]V[/TD]
[TD]W[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]Item[/TD]
[TD]Qty[/TD]
[TD]List[/TD]
[TD]Discount[/TD]
[TD]Final[/TD]
[TD]Amount[/TD]
[TD]Discount given[/TD]
[/TR]
[TR]
[TD]Gum[/TD]
[TD]7[/TD]
[TD]10.00[/TD]
[TD]3.50[/TD]
[TD]6.50[/TD]
[TD]65.00[/TD]
[TD]35%[/TD]
[/TR]
</tbody>[/TABLE]

So, now, I need a formula to go up to column A and look across to see what discount are allowed to give and then it would conditionally color the cell, under X with the discount they gave.

Gosh, I sound crazy. Does this sound like something that can be done?