Vlookup Across Multiple Files
You want just to do vlookup. But the difficulty is that you storage data in two different Excel files. The files are in the same directory and name Book1.xlsx and Book2.xlsx.
The simple vlookup formula would be:
In this case formula is:
To refer your vlookup formula to another Excel file just write [File_Name.extension]Sheet_Name!
If you have your data in Example_Name.xls in Sheet1 and A1:C100 cells the formula would be: