Try this:

Using VLOOKUP with an External Workbook and the INDIRECT Function