Select Page

How does VLOOKUP formula work in MS-EXCEL

Apr 14, 2019 | Blog | 0 comments

What is a v lookup in excel?

VLOOKUP is a popular formula in Microsoft Excel. It is basically used to find value within a particular cell with respect to a reference cell value in a large table.

Steps to write Excel vlookup formula:

Today we shall see how to do with this VLOOKUP formula.

Syntax of Vlookup :
 VLOOKUP (lookup_value, table_array, column_index_number, [range_of_lookup]) 

First of all , open an excel sheet and create a table of Product Detail, where Purchase Cost, MRP etc. are mentioned (Same as in the picture).

what is av lookup in excel,formula vlookup,what is av lookup,excel vlookup formula.


Below the table, select a cell and write- Type Product Name and beside that cell write –Purchase Rate.
So, we want to find out the purchase rate of product name, which we will type under that first cell. Here in the picture you can see that the Cell ID of that cell is – B10.

vlookup excel formula,excel vlookup example,vlookup excel function,vlookup function,vlookup example,vlookup excel example

And we have written the vlookup function in the cell, under Purchase Rate as –
=VLOOKUP (B10,A2:E7,4,TRUE)


Here B10 is the Cell No. of that place, where we shall type the product name.
A2:A7 is the table array range .You shall get this value, just after selecting the table.
4-It is the 4th column i.e. the column of Purchase Rate.
TRUE-Its used for approximate match(for exact match use FALSE).

That’s it. Now press Enter and required value will be shown in the box.Now change the product name . Then the Purchase rate will also be changed simultaneously.

Also Read:

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Pin It on Pinterest

Share This