Vlookup array - Excel tutorial 2025

 Vlookup array - Excel Tutorial 2025

Is image mein VLOOKUP function ko use karke ek row ke multiple values ko retrieve karne ki koshish ki gayi hai. Chaliye step-by-step samajhte hain:

---

📊 Source Table (Left Side)

Columns:

• Emp. Id (B3:B25): Unique employee IDs (e.g., a001, a002, etc.)
• Emp. Name (C3:C25): Employee names.
• Jan. Salary (D3:D25): January salary.
• Zone (E3:E25): Work zone.
• HRA (F3:F25): House Rent Allowance.
• Total (G3:G25): Total salary including HRA.

---

🧠 Right Table (Lookup Table)

Objective: VLOOKUP ka use karke Emp. Id ke basis par employee ke saare details fetch karna.

⚙️ Formula Explanation:

excel
=VLOOKUP(I12, B3:G25, {2,3,4,5,6}, 0)

• I12: Lookup value (e.g., a001)
• B3:G25: Table Array (Source data range, including Emp. Id to Total).
• {2,3,4,5,6}: Columns jo fetch karni hain:
  • 2: Emp. Name
  • 3: Jan. Salary
  • 4: Zone
  • 5: HRA
  • 6: Total
• 0: Exact match.

---

⚠️ Problem in Formula:

• VLOOKUP natively array lookup support nahi karta hai jab {2,3,4,5,6} ka use hota hai.
• Sirf ek hi column ko return kar sakta hai (e.g., Emp. Name ya Salary).

---

✅ Correct Approach:

Aapko har column ke liye alag-alag VLOOKUP lagana hoga:

1. Emp. Name:

   excel
   =VLOOKUP(I12, B3:G25, 2, 0)
   

2. Jan. Salary:

   excel
   =VLOOKUP(I12, B3:G25, 3, 0)
   

3. Zone:

   excel
   =VLOOKUP(I12, B3:G25, 4, 0)
   

4. HRA:

   excel
   =VLOOKUP(I12, B3:G25, 5, 0)
   

5. Total:

   excel
   =VLOOKUP(I12, B3:G25, 6, 0)