Lookup a range in another file?
 

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

Lookup a range in another file?
 

A lot of good info on efficiency he

http://www.decisionmodels.com/

--
Biff
Microsoft Excel MVP


"Joe" wrote in message
...
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

Lookup a range in another file?
 

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

Lookup a range in another file?
 

Yes. Use the workbook name and the range name for the table array:

=VLOOKUP(A2,'WorkbookName'!RangeName,2,FALSE)

This isn't going to improve performance though.

Cliff Edwards

Lookup a range in another file?
 

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

Lookup a range in another file?
 

Hi Joe,

That is not going to improve efficiency, in fact its going to slow things
down in most cases.
--
Cheers,
Shane Devenshire


"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