Tutorial excel vlookup. See the full tutorial at. Vlookup v stands for vertical is an in built function in excel which allows establishing a relationship between different columns of excel. This can be an actual value or a blank cell that will hold a value. The vlookup function in excel is used to find a value in a spreadsheet.
The syntax and arguments are vlookup searchvalue lookuptable columnnumber approximatematch this article explains how to use the vlookup function in all versions of excel including excel 2019 and microsoft 365. Use vlookup in the formula bar type vlookup. This video shows you how to use microsoft excels vlookup function to compare values in two lists.