Friday, 17 February 2017

VLOOKUP Formula in Excel

How to Use VLOOKUP Function Formula in Excel

VLOOKUP Function Formula is one of the lookup and reference functions, when you need to find things in a table or a range by row.

For example, look up an Product Quantity, Product Details or Product SKU, find any phone number by looking up Their last name (just like a telephone book Directory).

The secret to VLOOKUP Function Formula  is to organize your data so that the value you look up (Product Quantity) is to the left of the return value you want to find (Product Quantity's).   

VLOOKUP Function Formula Syntax : - 

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

For Example : - 


Argument name                      Description

lookup_value
    (required)         Which value you want to look up. Which value you want to look up must be in the first column of the range of cells you specify in table-array   (Lookup Value is C)

  For example, if table-array spans cells A:B, then your lookup_value must be in column C. See the below Details. Lookup_value can be a value or a reference to a cell


table_array    (required)            The range of cells in which the VLOOKUP will search for the lookup_value and the return value  (Table Array is A:B)  
 

 The first column in the cell range must contain the lookup_value (for example, A:B) The cell range also needs to include the return value


col_index_num    (required)       The column number starting with 1 for the left-most column of table-array that contains the return value   (Co_index No.2)


range_lookup   (optional)           A logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match:     (Range Lookup optional is FALSE)

         * FALSE searches for the exact value in the first column
 

         *  TRUE assumes the first column in the table is sorted either numerically or alphabetically, and will then search for the closest value. This is the default method if you don't specify one. 


        A                          B                        C                                     D
Product Name           Qty                 Product Name              Qty    (Result)
Saree                          5854              Tunic                              552   
Dress Material           8582              Shirt                               2524
Tops                           2854              Saree                             5854 
Shirt                           2524              Dress Material              8582
Tunic                          552                Tops                              2854




VLOOKUP Function Formula   : - 

=VLOOKUP(C:C,A:B,2,FALSE)
=VLOOKUP(C2,A:B,2,FALSE)


=VLOOKUP("Tops",A:B,2,TRUE)     For Use Only one Individual Products Quantity Result Find
                                                         
 

No comments:

Post a Comment