Hi All,

I hope someone can help me with the below:

I have a reference table like this where each cell within the table shows a specific price, depending on the item (a b c d e) and depending on how often that item is ordered (within a range)
If the amount of ordered is higher than 100, I take the

0-100 101-1000 1001-1500 1501-1700 1701- 1800 1801- 2000
a price #1 price #2 ...
b price #7 ....
c ....
d
e

Now I need to find a formula that would give me the exact price depending on the item and the amount ordered.
So ie: if item a is ordered 800 times I would get price #2.

I hope I have been clear.

Thank you and kind regards,
Sam