VLookup in Excel 2021 Tutorial

Watch this video

How to use VLOOKUP in Excel

1. Write the lookup value in one cell, then click on an empty cell adjacent to it. ...
2. In the formula bar, type “=VLOOKUP(“ without spaces. ...
3. Click on the cell containing the lookup value you entered. ...
4. In the formula bar, type “,” then click and drag to select the cells you want to search through.
5. Vlookup (V stands for 'Vertical') is an in-built function in excel which allows establishing a relationship between different columns of excel.

=VLOOKUP(What you want to look up, where you want to look for it, the column number in the range containing the value to return, return an Approximate or Exact ...

What is VLOOKUP? To begin with, it is an Excel function :) What does it do? It searches for the value you specify and returns a matching value from another column. More technically, the VLOOKUP function looks up a value in the first column of a given range and returns a value in the same row from another column.