PRICE level checking

[makinmomb]

Find attached , this saleman was not suppose to sell quantity 6 at discount , chart falls on no discount

What is the formula on 02 , to pull the price discount ( expected answer = 0% ) level from the table below , 0 50 , if 0 to 50 quantity is sold that price of item has no discount

[makinmomb]

The negative -6 can be over typed to positive 6 to avoid the formula convert negative to positives

[AZ-XL]

Hi
=INDEX(M4:M7,MATCH(ABS(H2),H4:H7,1))

[makinmomb]

I think maybe the table is not required, just if the formula can do the follow

check what qty is on h2 than,

if quantity is 0 to 50 it should write 0%
if quantity is 50 to 100 it should write 17%
if quantity is 101 to 200 it should write 22%
if quantity is 200 to 1000 it should write 28%

Its a multiple level if formula i think

[AZ-XL]

Is this what you want?

See the attached file

[makinmomb]

This is AZ-XL , need not to struggle if the multiple level , though how would the multiple if look like on this one ?
I shall be able to neck the team for those who sell outside the setted parametres , thank you again