Process of vlookup or hlookup
Below is a clear, step-by-step explanation of VLOOKUP and HLOOKUP with worked examples and a practice sheet you can try in Excel or Google Sheets.
1️⃣ VLOOKUP (Vertical Lookup)
📌 What VLOOKUP does
VLOOKUP searches for a value vertically (down a column) and returns a related value from another column in the same row.
Syntax
VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Meaning of each part
| Argument | Meaning
| lookup_value | Value you want to search |
| table_array | Data range |
| col_index_num | Column number to return |
| range_lookup | TRUE = approximate, FALSE = exact match
### ✅ Example 1: Student Marks
| A (ID) | B (Name) | C (Marks)
| 101 | Rahul | 85 |
| 102 | Anita | 92 |
| 103 | Mohan | 78 |
👉Question:Find marks of student with ID 102
Formula:
=VLOOKUP(102, A2:C4, 3, FALSE)
Answer: `92`
Explanation:
* Look for **102** in column A
* Return value from **3rd column**
* Exact match (`FALSE`)
Important Rules of VLOOKUP
1. Lookup value must be in **first column**
2. Cannot look **left**
3. Column number is **fixed**
4. Use `FALSE` for exact match (recommended)
2️⃣HLOOKUP (Horizontal Lookup)
What HLOOKUP does
HLOOKUP searches **horizontally (across a row)** and returns a value from a specified row.
### 📐 Syntax
```
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
### ✅ Example 2: Monthly Sales
| A | B | C | D |
| ----- | ---- | ---- | ---- |
| Month | Jan | Feb | Mar |
| Sales | 5000 | 7000 | 6500 |
👉 **Question:** Find sales for **February**
**Formula:**
```
=HLOOKUP("Feb", A1:D2, 2, FALSE)
```
**Answer:** `7000`
---
## 3️⃣ VLOOKUP vs HLOOKUP
| Feature | VLOOKUP | HLOOKUP |
| ---------------- | ------------ | ----------- |
| Search Direction | Vertical | Horizontal |
| Lookup Value | First column | First row |
| Usage | Most common | Less common |
---
## 4️⃣ Practice Sheet (Try Yourself)
### 🔹 Practice Table 1 (VLOOKUP)
| A (Emp ID) | B (Name) | C (Department) | D (Salary) |
| ---------- | -------- | -------------- | ---------- |
| E01 | Aman | HR | 30000 |
| E02 | Riya | IT | 45000 |
| E03 | Karan | Sales | 40000 |
| E04 | Neha | Finance | 50000 |
**Questions:**
1. Find salary of employee **E03**
2. Find department of **E02**
3. Find name of employee **E04**
---
### 🔹 Practice Table 2 (HLOOKUP)
| A | B | C | D | E |
| ------- | ---- | ------- | ------- | ------- |
| Subject | Math | Science | English | History |
| Marks | 88 | 91 | 85 | 90 |
**Questions:**
1. Find marks for **English**
2. Find marks for **History**
Comments
Post a Comment