Function: HLOOKUP()

🧭 Purpose:

The HLOOKUP() function (Horizontal Lookup) searches for a value in the first row of a table and returns a value from another row in the same column.

It works just like VLOOKUP(), but horizontally — perfect when your data is organized across columns instead of down rows.

🧮 Syntax:

Parameters:

📘 Explanation:

Imagine your data runs left to right (month names across the top).
HLOOKUP searches the top row, finds the match, and returns the value from the row you specify.

Example:

✅ This looks for “Mar” in the first row (A1:G1) and returns the value from the 3rd row of the matching column.

📊 Example 1: Monthly Sales Record

Formula:

✅ Result → 90000

📈 It finds “Mar” in the first row and returns the revenue from the 3rd row.

🏫 Example 2: Student Attendance Summary

Formula:

✅ Result → 4 (Absent days for Kunal)

⚙️ Pro Tips

• Use FALSE for exact matches — TRUE often gives wrong results unless sorted.

• Lock table references:
  =HLOOKUP(A2, $A$1:$F$3, 3, FALSE)

• Combine with IFERROR() to avoid errors:
  =IFERROR(HLOOKUP(A2, $A$1:$F$3, 3, FALSE), "Not Found")

🧩 Project Tasks for Students

🧠 Project 1 (Basic): Student Marks Extractor

🎯 Task: Create a formula that finds Riya’s marks in Computer using HLOOKUP.

👉 Formula:

✅ Result → 90

🏪 Project 2 (Basic): Shop Daily Sales Lookup

🎯 Task: Find Thursday’s total customers.

Formula:

✅ Result → 60

💼 Project 3 (Intermediate): Quarterly Profit Dashboard

🎯 Task:
Create a dynamic cell (G1) where user enters a quarter (like “Q3”), and use HLOOKUP to fetch:

• Total Sales

• Total Expenses

• Total Profit

👉 Example:

✅ Result (for Q3) → 16 Lakh

💡 Try combining this with IFERROR() and conditional formatting for a professional dashboard.

🧮 Project 4 (Hard): Regional Sales Report with Dynamic Input

🎯 Task:

1. Create an input cell for Region (like “South”).

2. Create another for Quarter (like “Q3”).

3. Use HLOOKUP() with a combination of MATCH() to make the lookup fully dynamic.

👉 Formula:

✅ If G2 = “South” and G3 = “Sales Q3 (₹)”, the result → 115000

💡 This makes your lookup flexible to both row and column changes — perfect for dashboards.

🏦 Project 5 (Hard): Bank Interest Rate Analyzer

🎯 Task:
Create a dynamic dashboard where user inputs:

• Loan Type (e.g., “Car”)

• Year (e.g., “2024”)

and HLOOKUP returns the correct Interest Rate.

👉 Formula:

✅ Output: 9.5%

💡 Combine this with Data Validation lists for a smooth user interface.

✅ Key Tip:
Use HLOOKUP() + MATCH() to make your lookups flexible for future changes — ideal for report automation and dashboards.