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:
=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.
