FUNCTION CATALOGUE / LOOKUP & REFERENCE
HLOOKUP Excel function
Looks up a value in the first row of a table.
Correct sentence to use
Find [lookup value] in the first row of [table] and return row [index].
Modify this query in PlainFormula →Example formula
=HLOOKUP(B5,A1:F3,3,FALSE)
Looks horizontally across the first row.
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Argument signature: lookup_value, table_array, row_index_num, [range_lookup]
Availability note
Commonly available in current Excel; verify platform and locale-specific behaviour.