can a vlookup formula reference a named range in another workbook?

Yes. You have to include the path if the source file will be closed:

Table = named range in XXX.xls
Refers to: Sheet1!A1:D4

=SUM('C:\TV\xxx.xls'!table)

I don't think this will help from an efficiency standpoint, though. The
formula still has to calculate and now it has to link to an external source.


--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
Thanks for the useful link.

However can a vlookup formula reference a named range in another workbook?

"Joe" wrote:

The current file has multiple tabs with many lookup formulas and the
performance is slowing down considerably.

I have 4 main tabs which contain the source data name ranges. Can I move
these tabs to a separate file and have the lookup formulas in the
original
file reference the ranges in this new file?

Any help would be appreciated.

Thanks, Joe