Excel Tutorial Using VLOOKUP() function (step by step tutorial) How to use VLOOKUP() function in Excel using VLOOKUP function Solution of this problem. You can use the VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range. Syntax: VLOOKUP (lookup_value, table_array, col_index_num, [range_lookup]) The VLOOKUP function syntax has the following arguments: lookup_value: Required. The value to search in the first column...