Can a Named-range be accessible from another Spreadsheet

Hi John and welcome to the forum,

The below website says exactly that: Named ranges do not work across different workbooks. But.. Read what they say and perhaps you can do a fixed range. ALSO - Power Query will work across multiple workbooks and even with all files in a folder. You'll need a newer version of Excel to get Power Queries.

http://www.ashishmathur.com/force-ex...oss-workbooks/

In my example I can use INDIRECT with VLOOKUP to work on named ranges within other workbooks BUT only if the other workbooks are open.

INDIRECT does not work with closed workbooks.

Thanks Andy,

I stand corrected..

Marv

The issue is INDIRECT and closed workbooks.
If you know the names of the books and the ranges within each book then you can use the CHOOSE function to return a reference to the range without INDIRECT

USE_REMOTE =CHOOSE(Sheet1!$C$3,USE_REMOTE_1,USE_REMOTE_2)
USE_REMOTE_1 ='C:\Temp\Book1.xlsx'!REMOTE_BOOK1_LOOKUP
USE_REMOTE_2 ='C:\Temp\Book2.xlsx'!REMOTE_BOOK2_LOOKUP

And the named ranges REMOTE_BOOK1_LOOKUP and REMOTE_BOOK2_LOOKUP are ranges defined and contained within each of the separate workbooks.