Combine tables using the VLOOKUP function We use the VLOOKUP function to combine/merge 2 tables which use the same keyword. This could be useful in many ways, so it is an important function to remember. =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) [lookup_value] = Input character or number that would be the base for search. [table_array] = Select・・・