Explanation

HLOOKUP searches for a value in the top row of a table and returns a value from a specified row.

Syntax

=HLOOKUP(lookup_value,table_array,row_index_num,[range_lookup])

Example

Formula:

=HLOOKUP(“Mar”,B1:E4,4,FALSE)

Result:

32000

Real-World Uses

• Monthly reports
• Horizontal data tables
• Financial summaries
• Department-wise reports

Practice

Create a monthly sales table and use HLOOKUP to retrieve sales and profit for a selected month.