Now combine multiple lookup functions in practical business scenarios.
Employee Database
|
Employee ID |
Employee |
Department |
Salary |
|
E101 |
Amit |
Sales |
45000 |
|
E102 |
Neha |
HR |
50000 |
|
E103 |
Rahul |
IT |
65000 |
|
E104 |
Priya |
Finance |
55000 |
If the user enters Employee ID in F2:
Employee Name:
=XLOOKUP(F2,A2:A5,B2:B5,”Not Found”)
Department:
=XLOOKUP(F2,A2:A5,C2:C5,”Not Found”)
Salary:
=XLOOKUP(F2,A2:A5,D2:D5,”Not Found”)
Alternative INDEX + MATCH
=INDEX(D2:D5,MATCH(F2,A2:A5,0))
This creates a simple Employee Lookup System