Table of Contents
🔹 What is HLOOKUP in Excel?
HLOOKUP (Horizontal Lookup) is used to search for a value in the first row of a table and return data from a specific row below it.
🔹 Example: Using HLOOKUP to Find Product Price
📝 We have the following table:
Product ID | Product Name | Price | Quantity Sold |
101 | Laptop | 50000 | 20 |
102 | Phone | 30000 | 50 |
103 | Tablet | 20000 | 30 |
📌 Formula to Find the Price of a Product by ID:
=HLOOKUP(A11, B3:F5, 3, FALSE)
🔹 Explanation:
- A11 → The lookup value (Product ID).
- B3:F5 → The table range.
- 3 → The row number to return data from (Price row).
- FALSE → Exact match required.
✅ Now, enter the Product ID in A11, and Excel will return the corresponding price! 🚀