🔹 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 IDProduct NamePriceQuantity Sold
101Laptop5000020
102Phone3000050
103Tablet2000030

📌 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! 🚀

Example:

Leave a Reply

Your email address will not be published. Required fields are marked *

Pinterest
Instagram