Vlookup. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. Vlookup is an excel function to look up data in a table organized vertically.
In its simplest form the vlookup function says. The syntax and arguments are vlookup search value lookup table column number approximate match this article explains how to use the vlookup function in all versions of excel including excel 2019 and microsoft 365. The vlookup function in excel is used to find a value in a spreadsheet.
The vlookup function always looks up a value in the leftmost column of a table and returns the corresponding value from a column to the right.
Vlookup supports approximate and exact matching and wildcards for partial matches. In other words it allows you to find look up a value from one column of data and returns it s respective or corresponding value from another column. This can be an actual value or a blank cell that will hold a value. For example the vlookup function below looks up the first name and returns the last name.
