Hi all.


I´m trying to figure out how to find the price of something in a list that depends of the price break reached...and the break point change with each item.

Reference Description Breakpoint €/kg Breakpoint €/kg
A Apples 1 2 3 1.5
B Bananas 1 3 6 2

So here if I use VLookup to a fix break point is fine but I do not know how to use when the breakpoint changes

Please have a look at the file attached

Cheers.
Adrian

Attached Files

Prices with different breakpoint.xlsx (8.8 KB, 12 views)