📌 If your Excel version supports XLOOKUP, prefer it over VLOOKUP.

💼 9. Real-World Business Scenario

Employee Database: E101 Rahul Sales 50000, E102 Priya HR 60000, E103 Amit IT 70000 

Requirement: Enter an Employee ID and automatically return Name, Department, Salary

Using XLOOKUP:

=XLOOKUP(F2,A2:A4,B2:B4,"Not Found") for Name

=XLOOKUP(F2,A2:A4,C2:C4,"Not Found") for Department

=XLOOKUP(F2,A2:A4,D2:D4,"Not Found") for Salary 

📌 This is a common interview and workplace scenario.

🎯 Mini Practice Project

Create: Employee_Lookup.xlsx 

Data: E101 Rahul Sales 50000, E102 Priya HR 60000, E103 Amit IT 70000, E104 Neha Finance 65000

Tasks:

✅ Find Salary using VLOOKUP

=VLOOKUP("E103",A2:D5,4,FALSE)

✅ Find Position using MATCH

=MATCH("Neha",B2:B5,0)

✅ Return Department using INDEX + MATCH

=INDEX(C2:C5,MATCH("E102",A2:A5,0))

✅ Return Salary using XLOOKUP

=XLOOKUP("E101",A2:A5,D2:D5,"Not Found")

📌 Mastering lookup functions is essential for Excel interviews and day-to-day data analysis.

Join our telegram channel: https://t.me/excel_data

➡️ Double Tap ❤️ For More