Can VLOOKUP be used to reference another workbook?

[Dan]

I was wondering if the VLOOKUP function can be used to
reference another Excel file, or if the table array has to
be from the same workbook (Excel file) as the worksheet
that is using the function. I know you can reference
another worksheet (I've done that in the past), but I
wasn't sure if you could reference another Excel file. I
have tried this, and couldn't get it to work, but I could
be doing it incorrectly.

Thanks for the info.


-Dan.

 

[Adrian]

Yes you can reference another worksheet or workbook.

Worksheets: enter "sheetname!" before the cell reference. ex.
=sheet2!a1+sheet3!a1

HTH.