All functions / Lookup
HLOOKUP
Finds a value in the first row of a table and returns a value from the same column.
Syntax
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Arguments
lookup_value: What to look for in the first row.table_array: The table. Its first row is searched.row_index_num: Which row to return (1 = first row).range_lookup(optional): FALSE for an exact match.
Example
=HLOOKUP("Mar", A1:M3, 2, FALSE) → Row 2 under "Mar"