This article explains how to use the VLOOKUP function in all versions of Excel, including Excel 2019 and Microsoft 365.
How to use the VLOOKUP function in Excel
The VLOOKUP function in Excel is used to find something in a table. If you have rows of data that are organized by column headings, you can use VLOOKUP to find a value using the column.
When you perform a VLOOKUP operation, you instruct Excel to first locate the row that contains the data you want to retrieve and then return the value located in a specific column in that row.
There are four possible parts of this function:
