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
Bookmarks