How to Use VLOOKUP to Merge Files. The VLOOKUP spreadsheet function searches an array of cells for a specific value, and returns the value of a cell adjacent to the target data.

Load up Excel. Then click "File," then "Open," and browse to the location of the spreadsheet to which you want to add a Vlookup. If the file containing the data you want to look up is on another ...