HLOOKUP Function Overview

Definition

• HLOOKUP stands for Horizontal Lookup.
• Used to search for a value in a horizontal table and return a value from a specified row.

Table Structure

• In HLOOKUP, the data is arranged in horizontal tables (i.e., row headings instead of column headings).

Example Table

• Top Products: Mobile Phone, Camera, etc.
• Columns: Product Code, Quantity, Price

How to Use HLOOKUP

1. Formula Structure: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
   • lookup_value: The value you want to find (e.g., a specific product like Mobile Phone).
   • table_array: The range of cells containing the data.
   • row_index_num: The row number in the table from which to return the value (e.g., price).
   • range_lookup: Optional; FALSE for an exact match, TRUE for an approximate match (0 is equivalent to FALSE).

Example Calculation

• To find the price of Mobile Phone:

  • HLOOKUP Formula: =HLOOKUP("Mobile Phone", A1:D4, 4, FALSE)
  • Result: $26.95

• For another product, like Cosmetics:

  • HLOOKUP Formula: =HLOOKUP("Cosmetics", A1:D4, 4, FALSE)
  • Result: $35.95

Key Differences from VLOOKUP

• HLOOKUP uses row index number instead of column index number found in VLOOKUP.
• Always ensure to specify the correct table structure when using HLOOKUP.

Conclusion

• HLOOKUP is an efficient way to retrieve data from horizontal tables and is very similar in function to VLOOKUP, with slight adjustments in the parameters used.

---