Accessing data from a data range using lower threshold.
Example for VLOOKUP, LOOKUP, INDEX/MATCH and IFS functions. Named ranges are used as well.
The cost for a certain volume should be returned that is higher than the last lower threshold and below the next higher threshold.
The example works in LibreOffice Calc. I assume it also works in Excel.