HLOOKUP()
Like VLOOKUP, but searches the top row of a range and returns a value from a row you specify below it.
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])HLOOKUP is VLOOKUP rotated 90 degrees: it searches across the first row of table_array for lookup_value, then returns a value from a row you specify, counting down from the top.
It's useful when data runs left-to-right instead of top-to-bottom — for example, months across columns with metrics stacked in rows below each one.
Arguments
- lookup_value
- The value to search for.
- table_array
- The range to search — the lookup row must be its first (top) row.
- row_index_num
- Which row to return from, counting from 1 at the top of table_array.
- range_lookupoptional
- FALSE for an exact match; TRUE or omitted for an approximate match on sorted data.
Examples
=HLOOKUP("Mar", A1:M5, 4, FALSE)→March's value from row 4
Finds "Mar" across row 1, returns the value 3 rows down.