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).
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.
And we have written the vlookup function in the cell, under Purchase Rate as –
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.