In Excel, the VLookup function searches for value in the left-most column of table_array and returns the value in the same row based on the index_number . The syntax for the VLookup function is: VLookup( value , table_array, index_number, not_exact_match)