Excel function VLOOKUP

The VLOOKUP function searches for a value in the first column of a table and then returns the contents of the cell located on the same row as the lookup value.

Let's try an example:

We want to return a candidate's first name based on his number.

In this case, we are looking for candidate 8's first name.

vlookup function

And the result is the first name of candidate 8.

Now, in order to search for another name, all we have to do is edit the contents of cell G2.