HLOOKUP

An exact lookup across a row instead of down a column, as in =HLOOKUP(F6,$E$11:$K$12,2,0), where the final 0 means exact match.

When to use

In the month calendar it turns the weekday number of the first day into a day name from a table that runs horizontally (numbers 1 to 7 above Sunday to Saturday). XLOOKUP is the modern alternative.

See Lec 04.

Appears in

No references yet.