Excel Challenge 4 - Employee Dataset 2

This week, we will be completing a table of employee information using only 2 columns of data. In order to do this, we will be referring to a table in another sheet and using the VLOOKUP formula.

Download the data set and complete the tasks below.


  1. Using the EmpID column link to the "Employees - Dataset 1" table to fill the Full Name, DateofHire and DateofTermination columns.
  2. Finally, the Current Employee column should be filled using a formula format which returns 'Yes' for current employees and 'No' for former employees.

The end result should like the table below:

Stuck on the tasks?

+ Reveal Step-By-Step Instructions

Sharpen your skills with our range of Excel courses designed to turn you from a table trainee to spreadsheet specialist here >