Scribd
Upload
9 views4 pages

VLOOKUP Practice Template for Employees

This document provides a template for practicing the VLOOKUP function using a realistic employee dataset. It includes instructions for retrieving various employee details such as department, salary, and location, as well as solving business problems like calculating bonuses. Additionally, it suggests using PivotXL for automating data retrieval and ensuring accurate financial reporting.

Uploaded by

Shyam Rajput
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
9 views4 pages

VLOOKUP Practice Template for Employees

This document provides a template for practicing the VLOOKUP function using a realistic employee dataset. It includes instructions for retrieving various employee details such as department, salary, and location, as well as solving business problems like calculating bonuses. Additionally, it suggests using PivotXL for automating data retrieval and ensuring accurate financial reporting.

Uploaded by

Shyam Rajput
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

:🎯 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

💡 Next Step: Automate It with PivotXL


This VLOOKUP practice template is a great way to learn the basics. But in real finance t
and maintaining formulas is time-consuming and error-prone. PivotXL connects directly
mappings automatically, and refreshes reports instantly — so your statements are alwa

📬 Sign up for Free

[Link]
h a realistic employee dataset. You’ll learn to:

okup table.
total compensation, and finding employees by criteria.

s. But in real finance teams, manually building lookups


votXL connects directly to your accounting data, applies
ur statements are always accurate and up to date.
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 Adams HR Chicago 55000 0.09
109 Irene Scott Finance Boston 68000 0.1
110 Jack White IT New York 85000 0.12

1. Find the Name of the employee with EmpID = 104.


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. Lookup the Location of 107.
9. Return the Department for employee 108.
10. Get the Name of employee 109.
11. Find the Salary of the employee in Boston (Finance).
12. Retrieve the Department of 101.
13. Find the Location of 105.
14. Return the Name of employee 106.

Q2. Below is a list of the employees who work in your


company:

EmployeName Location Salary Age


56815 Garry Manship Hong Kong 13836 25
51186 William Johnson Berlin 11771 32
51511 Thomas Bettle Bangkok 13046 35
50890 Ian Nash Cairo 18276 32
53700 Margaret Turley Shanghai 19327 26
55879 Michael Kaye Capetown 18996 35
59848 Paul Bell Bangkok 10387 25
58369 Thomas Davies Capetown 12566 37
50217 Eric Green Warsaw 16406 42
50695 Williamr Black Cairo 15784 43
59673 Estelle Cormack Hong Kong 10959 30
52130 Christopher Fallon Delhi 14562 32
What is the name of Employee ID 58369?

What's the age of Estelle Cormack?

Return the Location of the following employe

EmployeLocation
55879
50217
50695

Find the Salary of the following employees:

Name Salary
Ian Nash
Johnny Slash
Estelle Cormack

You might also like