Lesson 10 - VLOOKUP & XLOOKUP

🔎 Lookup Kya Hai?

Hindi: Lookup ka use kisi table mein ek value search karke usse related information find karne ke liye hota hai.

English: Lookup functions are used to search for a value and return related information from a table.

Employee ID → Employee Name
Product ID → Product Price
Customer ID → Customer City

📌 VLOOKUP Kya Hai?

VLOOKUP Excel ka ek popular lookup function hai. Iska use table ke first column mein value search karke related information return karne ke liye hota hai.

VLOOKUP ka "V" ka matlab Vertical hai.

Basic Syntax:

=VLOOKUP(lookup_value, table_array, col_index_num, FALSE)

👨‍💼 VLOOKUP Example

Maan lijiye employee table hai:

ID Name Department
101 Rahul Sales
102 Amit IT
103 Priya HR
104 Mohit Marketing

Agar hume ID 102 ka Name find karna hai:

=VLOOKUP(102,A2:C5,2,FALSE)

Result: Amit

🔢 Column Index Number

VLOOKUP mein col_index_num batata hai ki table ke kis column se result chahiye.

ID → Column 1
Name → Column 2
Department → Column 3

Agar Name chahiye to column number 2 hoga.

🎯 FALSE ka Use

VLOOKUP mein FALSE ka use exact match find karne ke liye kiya jata hai.

=VLOOKUP(102,A2:C5,2,FALSE)

Isse Excel exact value 102 search karega.

🚀 XLOOKUP Kya Hai?

XLOOKUP Excel ka modern lookup function hai. Ye VLOOKUP ke comparison mein zyada flexible hai.

XLOOKUP left aur right dono direction mein information find kar sakta hai.

Basic Syntax:

=XLOOKUP(lookup_value, lookup_array, return_array)

📊 XLOOKUP Example

ID Name
101 Rahul
102 Amit
103 Priya
104 Mohit

ID 103 ka Name find karna hai:

=XLOOKUP(103,A2:A5,B2:B5)

Result: Priya

⚖️ VLOOKUP vs XLOOKUP

VLOOKUP
→ Traditional lookup function
→ Vertical lookup
→ Column number use karta hai

XLOOKUP
→ Modern lookup function
→ More flexible
→ Lookup aur return range separately use karta hai

💼 Business mein Lookup

VLOOKUP aur XLOOKUP ka use professional Excel work mein bahut common hai.

• Employee Records
• Customer Records
• Product Lists
• Sales Data
• Lead Data
• Price Lists
• Stock Management

🛒 Product Price Example

Product ID Product Price
P101 Laptop ₹50,000
P102 Mouse ₹800
P103 Keyboard ₹1,500
P104 Monitor ₹12,000

Product ID se price find karne ke liye lookup function ka use kiya ja sakta hai.

=XLOOKUP("P103",A2:A5,C2:C5)

Result: ₹1,500

⚠️ Important Note

VLOOKUP aur XLOOKUP ka main purpose table se related information quickly find karna hai.

Modern Excel mein XLOOKUP ek powerful aur flexible option hai.

🎓 Lesson Summary

Is lesson mein humne seekha:

✅ Lookup kya hai
✅ VLOOKUP
✅ VLOOKUP Syntax
✅ Column Index Number
✅ Exact Match
✅ XLOOKUP
✅ XLOOKUP Syntax
✅ VLOOKUP vs XLOOKUP
✅ Business Examples
✅ Product Price Lookup