Named Range in another workbook

J

Jon C

Hi,

I'd like to be able to refer to a Named Range on another
workbook, let's call it Employees.xls, from a second
workbook, something like this.

=VLOOKUP(A3,Employees.xls!nEmployeeTable,2,FALSE)

Works a treat but only when the Employees workbook is
open. Is there a way around this or is it a 'feature'?

Thanks,

Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup a subtotal 2
Linked Named Ranges 2
Refer to a named range indirectly 1
References to external workbooks 4
Use Text and Cell vale to reference a named range inside a formula 4
trouble with (complicated) vlookup searching another workbook 2
Named Ranges and Dynamic Formulas 4
>> vlookup refering to a cell to get wookbook name 1

Top