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
graphic below. 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.
Continue.......
Page 2 >Page 3 >Page 4 >Page 5 >Page 6 >Page 7 >Page 8 >Page 9 >Page 10 >Page 11
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
graphic below. 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.
Continue.......
Page 2 >Page 3 >Page 4 >Page 5 >Page 6 >Page 7 >Page 8 >Page 9 >Page 10 >Page 11