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...