Top 15 Tutorial on VLookup

Top 15 Tutorial on VLookup 

1. Vlookup 

Is image mein Excel ka VLOOKUP formula use kiya gaya hai. Chaliye step-by-step samajhte hain:

📊 Left Table (Source Data) Explanation:

• Emp. Id (Column B): Employee ID (e.g., a001, a002, etc.)
• Emp. Name (Column C): Employee names.
• Jan. Salary (Column D): January salary figures.
• Zone (Column E): Geographical zone.
• HRA (Column F): House Rent Allowance.
• Total (Column G): Total calculated using the formula =D4+F4 (Salary + HRA).

🧠 Right Table (VLOOKUP Formulas):

1. Emp. Name (I4 to J4)

Formula:

excel

=VLOOKUP(I4, B3:F25, 2, 0)

• I4: Lookup value (Emp. Id, e.g., a014).
• B3:F25: Data range (Emp. Id to HRA).
• 2: Return the value from the 2nd column (Emp. Name).
• 0: Exact match.

Purpose: Is formula se Emp. Id ke basis par Employee ka naam fetch hota hai.

2. HRA (I8 to J8)

Formula:

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

• I8: Lookup value (Emp. Id, e.g., a014).
• B3:G25: Data range (Emp. Id to Total).
• 5: Return the value from the 5th column (HRA).
• 0: Exact match.

Purpose: Is formula se Emp. Id ke basis par HRA fetch hota hai.

3. Complete Row Lookup (I12 to N12)

Formulas:

• Emp. Name: =VLOOKUP(I12, B3:G25, 2, 0)
• Jan. Salary: =VLOOKUP(J12, C3:H25, 2, 0)
• Zone: =VLOOKUP(K12, D3:I25, 2, 0)
• HRA: =VLOOKUP(L12, E3:J2, 2, 0)
• Total: =VLOOKUP(M12, F3:K25, 2, 0)

Purpose:
Har column ka lookup value Emp. Id se match karke respective values (Name, Salary, Zone, HRA, Total) fetch karta hai.

✅ Conclusion:

• VLOOKUP ek powerful Excel function hai jo kisi ek specific value (Emp. Id) ke basis par data fetch karta hai.
• Lookup table mein har column ko specify karke hum alag-alag information retrieve kar sakte hain.