Vlookup Across Multiple Files

Vlookup Across Multiple Files

Your task

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:

=VLOOKUP($A$2,A1:B200,2)

In this case formula is:

=VLOOKUP($A$2,[Book2.xlsx]Sheet2!A1:B200,2)

Explanation

To refer your vlookup formula to another Excel file just write [File_Name.extension]Sheet_Name!

Example:

If you have your data in Example_Name.xls in Sheet1 and A1:C100 cells the formula would be:

=VLOOKUP($A$2,[Example_Name.xls]Sheet1!A1:C100,2)

Template

Further reading: 
How to create many to many lookup?
Backwards Vlookup
Basic concepts 
Getting started with Excel
Cell References