What is HLOOKUP?
Horizontal Lookup - searches for a value in the top row of a table and returns a value from a specified row. The horizontal counterpart to VLOOKUP.
Syntax
=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
Example
Formula: =HLOOKUP(\
Result: $15,000
How It Works
Searches for 'Q1' in the first row and returns the value from row 3 in the same column. Like VLOOKUP but for horizontally-arranged data. FALSE ensures exact match.