How to use VLOOKUP function in excel | VLOOKUP formula in excel with example

How to use VLOOKUP function in excel

Excel Vlookup is the most sought formula in excel and is widely used by everyone. It is used basically for looking up values vertically means from the column.

Before learning how to use vlookup excel we need to understand about different inputs of excel vlookup formula. As we can see below picture there are 4 different inputs required for using excel vlookup function.

The explanation of values are given as given below:

Let us understand this by and example.

In the below table we can see the name of the person and sales done by them on the month on month basis. Now we wanted to look up sales done by Bob for the month of Feb. Then we need to use Vlook up formula to get this value.

So Bob is here lookup_value that we wanted to look up in the table (table_array) and the column Feb from where value needs to pick up has a distance 3(col_index_num) from name columns.

So now we will use vlookup formula in next cell to value column and will get value of 90.

You also can see the video for more clarification.

You can read more about VLOOKUP from the below article.

https://exceljet.net/excel-functions/excel-vlookup-function

To read about HLOOKUP click the below link.

https://datawitzz.com/how-to-use-hlookup-in-excel/