Skip to main content

Build an employee VLOOKUP directory

100%
VLOOKUP

VLOOKUP searches the first column of a table and returns a value from another column in the same row. The column index is counted from the start of the selected table, not from the left edge of the sheet.

Use FALSE for an exact ID match. An approximate match can return the wrong employee when the rows are not ordered for that kind of search, and an ID lookup should never guess.

Use VLOOKUP in B4 and B5 to return the name and location for the employee ID in B2, using the directory in A9:D13.

The grid for this exercise is part of the paid half.

Everything above is yours to read either way. 46 exercises stay free with a profile.

Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).