How to Use VLOOKUP Function Formula in Excel

Sagar Guide - How to Use VLOOKUP Function Formula in Excel

VLOOKUP Function Formula is one of the most important formula in the world, 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 and their 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.

Screenshot Example - 1
 


Screenshot Example - 2

VLOOKUP Function Formula   : -

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