Excel Function: VLOOKUP

The Excel function VLOOKUP searches for a value in the first column of a table and then returns the value of a cell that is on the same row as the searched value.


=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)

Example of Use

The goal here is to look up information based on the file number. The user should be able to enter the file number in the green part and then see the result of his search in the blue part:

excel function vlookup

Select the VLOOKUP function and enter:

vlookup function

The name of the city is then displayed:


To then display the points, simply copy the formula and change the column number (replace 2 with 3):

excel function vlookup tutorial table
If needed, you can download the Excel file used here: vlookup.xlsx
To understand how to handle errors returned by the VLOOKUP function when the file number has not been found, check out the page of the function IFERROR.
The VLOOKUP function searches for a value in the first column of a table, so the results cannot be to the left of the search column. If you want to be able to search in a column that is not necessarily the first in the table, use the combination of functions INDEX + MATCH (or more simply the function XLOOKUP if you have Excel 365).