excel Using VLOOKUP to get a person's surname from their Employee ID


Example

Vlookup finds some value in the leftmost column of a range and returns a value some number of columns to the right and in the same row.

Let's say you want to find the surname of Employee ID 2 from this table:

list of employees

=VLOOKUP(2,$A$2:$C$4,3,0)
  • The value you're retrieving data for is 2
  • The table you're searching is located in the range $A$2:$C$4
  • The column you want to return data from is the 3rd column from the left
  • You only want to return results where there is an exact match (0)

Note that if there is no exact match on the employee ID, the VLOOKUP will return #N/A.