What is VLOOKUP and how to use it

What is VLOOKUP and how to use it?


VLOOKUP in Excel is a function that performs vertical lookup and searches for specific values in the first column of the excel sheet. It returns the value for the same row for the position in index_number.

An easy example would be – having a list of fruits along with their pricing. Now, if you want to find out the price of a particular fruit using this function then you would use VLOOKUP. click here for further details.

The VLOOKUP feature in Excel in a built-in one and falls under the category of Looku or Reference function.One can also use it as worksheet function. As a WS function, VLOOKUP is entered as part of the formula in a worksheet cell.

This function is really easy to understand once you figure out how exactly it works. Read this tutorial to know more about it.

How to work with it

Like any other formula, this one will also start with an equal (=) sign. You can use the formula in any blank cell of the sheet. So, it should look something like this –


Adding the Arguments

The purpose of the argument is to tell the function(VLOOKUP) what and where to search for a particular value.

Name of the item being searched is going to be the first argument. IN this case, the first argument will be Banana. The argument will need to be in double quotes since it’s a text. Therefore, it should look like this. for more details, visit : https://www.collin.edu/ce/courses/excelI.html

What is VLOOKUP and how to use it


The second argument will have to be the cell range containing the data. So, in this case, the data is in A2:B16. You’ll need to use ‘comma’ to separate each argument.

=VLOOKUP(“Banana”, A2:B16

The third argument is going to be the column index number. Since, we’re trying to find the price of the fruit, which is in the second column, therefore our third argument, will be ‘2’ which is the column number.

=VLOOKUP(“Banana”, A2:B16, 2

The fourth argument is either TRUE or FALSE. TRUE argument will look for approximate matches within the given range. This is typically used when there are sorted numerical values in the first column. But, since we are looking for exact matches, we will use FALSEargument. After this, we will close it with parenthesis.

=VLOOKUP(“Banana”, A2:B16, 2, FALSE)

Press enter and youwill get the answer like this –

Special Note – Remember that this function always searches the first column in the given range.So, in the current example it will start off by searching through Column A for the Banana.…