HLOOKUP Function 2

Freeintermediate 15 min4 tasks0/72 pts

More HLOOKUP: approximate match works across a row too (thresholds in the top row, sorted ascending), MATCH can pick the row number by label, and IFERROR hides missing headings.

Syntax

HLOOKUP(value, table, MATCH(label, labels, 0), FALSE)

Common mistakes

Thresholds in the top row not sorted ascending.
Hard-coding the row number.

HLOOKUP Function XLOOKUP Function