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

A	b	c	d	e
Low Qty	High Qty	Discount 1	Discount 2	Discount 3
15	24	0	5	10
25	34	5	10	15
35	54	10	15	20
55	199	15	20	25
200		20	25	30

<tbody>
</tbody>

SO, the sheet they are working on will look like this

R	S	T	U	V	W	X
Item	Qty	List	Discount	Final	Amount	Discount given
Gum	7	10.00	3.50	6.50	65.00	35%

<tbody>
</tbody>

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?