Question: Below is an Employee Dataset. Write a VLOOKUP formula on the dataset to solve all the below problems. Find the First Name and Last Name
Below is an Employee Dataset. Write a VLOOKUP formula on the dataset to solve all the below problems.
Find the First Name and Last Name of Employee ID listed at cell C PTS
Construct a similar formula to find the First Name and Last Name of Employee ID listed at cell C but this time if an Employee ID doesn't exist, the First Name
should show "Not Found" and Last Name show "Not Exist" PTS
Construct a formula to return the Start Date of "Victoria Allen" in MMDDYY FORMAT. PTS
Points Total
DO NOT HARDCODE THE VALUES IN THE FORMULAS
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
