Data lookup in spreadsheet

Estimated reading time of this article: 1 minute

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.

Files: