HLOOKUP(...)
Using HLOOKUP() function to retrieve values in tables.
Used Functions
Category: Lookup and reference
Looks in the top row of an array and returns the value of the indicated cell
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Practice HLOOKUP Formula at Sheetzoom
HLOOKUP formula at Microsoft help
0
Unlike vlookup that looks for values in column, HLOOKUP() looks for values in rows, and retrieves values from a given row, with exact or approximate matches. The first argument of the function is lookup_value, the second is lookup_table, the third is "row offset" and the fourth is true or false based on exact or approximate match.