Scribd
Upload
24 views2 pages

Vlookup Example

The document lists employee details including EmpID, Name, Department, Location, Salary, and Bonus %. It also includes various lookup tasks using VLOOKUP to retrieve specific information about employees based on their EmpID. The document contains multiple entries for employees and their respective data, along with some calculations related to salary and bonuses.

Uploaded by

John Michael Omao
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
24 views2 pages

Vlookup Example

The document lists employee details including EmpID, Name, Department, Location, Salary, and Bonus %. It also includes various lookup tasks using VLOOKUP to retrieve specific information about employees based on their EmpID. The document contains multiple entries for employees and their respective data, along with some calculations related to salary and bonuses.

Uploaded by

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

EmpID Name Department Location Salary Bonus %

101 Alice Wong Finance New York 65,000 10%


102 Bob Smith Marketing Chicago 72,000 12%
103 Carol Jones IT San Diego 80,000 8%
104 David Chen HR New York 58,000 9%
105 Emily Davis Finance Chicago 62,000 11%
106 Frank Lee Marketing Boston 76,000 10%
107 Grace Hall IT San Diego 82,000 7%
108 Henry Adams HR Chicago 55,000 9%
109 Irene Scott Finance Boston 68,000 10%
110 Jack White IT New York 85,000 12%
EmpID Name Department Location Salary Bonus %
101 Alice Wong Finance New York 65,000 10%
102 Bob Smith Marketing Chicago 72,000 12%
103 Carol Jones IT San Diego 80,000 8%
104 David Chen HR New York 58,000 9%
105 Emily Davis Finance Chicago 62,000 11%
106 Frank Lee Marketing Boston 76,000 10%
107 Grace Hall IT San Diego 82,000 7%
108 Henry Adams HR Chicago 55,000 9%
109 Irene Scott Finance Boston 68,000 10%
110 Jack White IT New York 85,000 12%

ANSWER FORMULA
Find the Name of the employee with EmpID = 104. David Chen VLOOKUP(104,A2:F11,2,FALSE)
Find the Department of employee 106. Marketing VLOOKUP(106,A2:F11,3,FALSE)
Find the Salary of employee 102. 72,000 VLOOKUP(102,A2:F11,5,FALSE)
Retrieve the Bonus % for EmpID = 109. 10% VLOOKUP(109,A2:F11,6,FALSE)
Find the Location of employee 101. New York VLOOKUP(101,A2:F11,4,FALSE)
Using EmpID, get the Salary of 110. 85,000 #N/A
Retrieve the Department of 103. IT #N/A
Find the Name of the employee who earns 62,000. Emily Davis #N/A
Find the Salary of 105 and add the Bonus % to compute total compensation. 68820 #N/A
Lookup the Location of 107. San Diego #N/A
Find the Bonus % of 102 and calculate the Bonus Amount. 8640 #N/A
Return the Department for employee 108. HR #N/A
Get the Name of employee 109. Irene Scott #N/A
Find the Salary of the employee in Boston (Finance). 68,000 #N/A
Retrieve the Department of 101. Finance #N/A
Find the Bonus % of the highest-salary employee (EmpID 110). 12% #N/A
Lookup the Salary for 103 and apply a 5% increment. 84000 #N/A
Find the Location of 105. Chicago #N/A
Return the Name of employee 106. Frank Lee #N/A
For EmpID 107, calculate Salary + (Salary * Bonus %). 87740 #N/A

You might also like