Skip to content
MathJet Docs

hlookup

Horizontal lookup in a table.

Syntax

Section titled “Syntax”
v = hlookup(lookup_value, table_array, row_index_num, range_lookup)

Description

Section titled “Description”

Like vlookup but searches across the first row and returns from row row_index_num. Useful when data is laid out with categories as columns and observations as rows.

Example

Section titled “Example”
hlookup('Q1', T, 3, false)

See also

Section titled “See also”
  • vlookup — Vertical lookup in a table.
  • xlookup — Modern lookup with optional default and search direction.