Index Match Vlookup Array or Similar

Hi, I'm looking for help with a formula.

I have a list of products and a price list. In one field I have the quantity sold. Now depending on how many sold their is a tiered structure for the pricing.

What I need help with is returning the correct value when the quantity sold is between the range.

I can get it to work if the quantity sold is either the minimum or the maximum in the range but not inbetween.

SampleData.xlsx

Any help would be much appreciated,

Dave

Dear djm601,
Please see the solution in the attached file.

Note that after writing this formula you should use Ctrl+Shift+Enter, because it is an array formula solution.

Hope this will help.

Regards and best wishes.

D080

Just what I needed thanks,

appreciate your help.
Cheers,

Dave

Glad to help.

Giorgi