Merging Excel Files Based on Column with INDEX and MATCH Functions Read More: How to Merge Excel File to Mailing Labels (With Easy Steps)Ģ. Thus you can merge excel files based on a column by using the VLOOKUP Function. After that, use the Fill Handle to AutoFill lower cells.Press the ENTER button and you will see the salary of Jason Campbell whose name is in cell B5.We want exact match of the names so we chose FALSE.
We set the column index number as 2 because the salaries are in the 2nd column. Here, the VLOOKUP Function looks for the value in cell B5, searches this value in range B5:C11 of the Merge Files (lookup) file (keep that in mind that we have to use Absolute Cell Reference) and returns corresponding salary for the guy in cell B5.
