VLOOKUP / EXCELL VLOOKUP FUNCTION / EXCEL VLOOKUP FORMULA / MS EXCEL VLOOKUP

VLOOKUP / EXCELL VLOOKUP / VLOOKUP FUNCTION / EXCEL VLOOKUP FORMULA / HOW TO USE VLOOKUP IN EXCEL SPREADSHEET? / VLOOKUP EXAMPLE 2007/ VLOOKUP FUNCTION EXAMPLE / VLOOKUP FORMULA EXAMPLE / EXAMPLES OF VLOOKUP / VLOOKUP DESCRIPTION WITH EXAMPLE.

Here we are going to discuss the most important and most useful function / formula of MS Excel i.e VLOOKUP. About every person who works on MS Excel, use VLOOKUP as VLOOKUP is a very useful and powerful function / formula for MS Excel. Basically we use VLOOKUP for put a data or value from another table into one table with the basis of a common value, cell, range or data either the table is from the same spreadsheet or different spreadsheet, or we can say that we fetch a data / value from another table into one table with the help of VLOOKUP FUNCTION in MS Excell. So Here we use VLOOKUP with an example. We discuss, how to use VLOOKUP / Put VLOOKUP in cell or range of cells in Excel Spreadsheet.

Now lets start using VLOOKUP Function / VLOOKUP Formula in Excel, suppose we have two table one is Sales Table which contains sales data of the products and another is Product Table which contains the product information of Products. The Product Name column contains the matched values of products in both the tables.

Table 1:-Sales Table which contains the sales information of the products. There are two columns in Table 1-Sales, Column A is Product Name and Column B is Sales.

Table 2:-
Product Table which contains the Product information of the products. There are two columns in Table 2-Products too. Column A is Product Name and Column B is Product Price.

Now in Table 1-Sales, if we want to insert / fill / fetch product price from Table 2-Product we will have to use MS Excel / Excell VLOOKUP Function / VLOOKUP Formula to fetch or fill the values of product price column in Table 1-Sales from another table 2-Product.

MS Excel VLOOKUP Formula / VLOOKUP Function:-

=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]

>Lookup_value is the value to be found in the first column of the table, and it can be value, a reference, or a text string.

Remember:- Lookup_value should be in the left of the data always, vlookup doesn't insert / fill / fetch values in the left hand side from the lookup_value.

>Table_array is a table of text, numbers, or logical values, in which data is retrieved, Table_array can be a reference to a range or a range name

>Col_index_num is the column number in table_array from which the matching value should be returned. The first column of values in the table is column 1.

>Range_lookup is a logical value: to find the closest match (approx match) in the first column (sorted in ascending order)=TRUE or omitted; find an exact match = FALSE.

Note:- we can write 1 instead of TRUE in range_lookup and can write 0 instead of FALSE in range_lookup. It's a time consuming activity in Excel VLOOKUP Formula.

Now in Table 1-Sales give Column C name Product price and write the VLOOKUP formula as:-

=VLOOKUP(A3,Products!A3:B9,2,0)

In this Formula:-

A3 is the lookup value which is being search in table 2-Products.

Products!A3:B9 is the range of table from which we want to insert / fetch / fill the data.

2 is the column_index_num, which column value we want. First we select a range of table from A3 to B9 in this total no of Row are from 3-9 means 6 rows and Column from A-B means 2 Columns and we want 2nd column (B Column value) so here we put 2 as a column_index_num.

0 is the range_lookup, we want here exact match so we write 0.