VLookup Practice Problems
Brought to you by PivotXL
[Link]
:🎯 What This Template Teaches
This template helps you practice using the VLOOKUP function with a realistic employee
Write VLOOKUP formulas to retrieve data by ID or key field.
Return information like department, salary, or location from a lookup table.
Solve real-world business problems such as calculating bonuses, total compensation, an
criteria.
💡 Next Step: Automate It with PivotXL
This VLOOKUP practice template is a great way to learn the basics. But in real finance t
lookups and maintaining formulas is time-consuming and error-prone. PivotXL connect
accounting data, applies mappings automatically, and refreshes reports instantly — so
always accurate and up to date.
📬 Sign up for Free
[Link]
e Problems
XL
ealistic employee dataset. You’ll learn to:
table.
compensation, and finding employees by
in real finance teams, manually building
PivotXL connects directly to your
s instantly — so your statements are
EmpID Name Department Location Salary Bonus %
101 Alice Wong Finance New York 65000 0.1
102 Bob Smith Marketing Chicago 72000 0.12
103 Carol Jones IT San Diego 80000 0.08
104 David Chen HR New York 58000 0.09
105 Emily Davis Finance Chicago 62000 0.11
106 Frank Lee Marketing Boston 76000 0.1
107 Grace Hall IT San Diego 82000 0.07
108 Henry AdamsHR Chicago 55000 0.09
109 Irene Scott Finance Boston 68000 0.1
110 Jack White IT New York 85000 0.12
For Solutions - Look up the following article
[Link]
Problem Solution
1. Find the Name of the employee with EmpID = 104. David Chen
2. Find the Department of employee 106.
3. Find the Salary of employee 102.
4. Retrieve the Bonus % for EmpID = 109.
5. Find the Location of employee 101.
6. Using EmpID, get the Salary of 110.
7. Retrieve the Department of 103.
8. Find the Name of the employee who earns 62,000.
9. Find the Salary of 105 and add the Bonus % to compute total compensation.
10. Lookup the Location of 107.
11. Find the Bonus % of 102 and calculate the Bonus Amount.
12. Return the Department for employee 108.
13. Get the Name of employee 109.
14. Find the Salary of the employee in Boston (Finance).
15. Retrieve the Department of 101.
16. Find the Bonus % of the highest-salary employee (EmpID 110).
17. Lookup the Salary for 103 and apply a 5% increment.
18. Find the Location of 105.
19. Return the Name of employee 106.
20. For EmpID 107, calculate Salary + (Salary * Bonus %).
xercises/