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.

How to use VLOOKUP in excel
Vlookup formula

The explanation of values are given as given below:

How to use VLOOKUP in excel
How to use VLOOKUP in excel

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.

How to use VLOOKUP function in excel
How to use VLOOKUP function in excel

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

vlookup
vlookup understanding

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/

3 thoughts on “How to use VLOOKUP function in excel | VLOOKUP formula in excel with example”

  1. Pingback: How to use XLOOKUP in excel: Understanding it with 3 examples - DataWitzz

  2. Pingback: VLOOKUP and MATCH combo function in excel : How to create a dynamic VLOOKUP in excel ||DataWitzz - DataWitzz

  3. Pingback: How to return a value if the VLOOKUP value is in a range || Excel VLOOKUP ||DataWitzz - DataWitzz

Leave a Comment

Your email address will not be published. Required fields are marked *