ExcelBanter - Named Range in another workbook

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Named Range in another workbook (https://www.excelbanter.com/excel-worksheet-functions/13688-named-range-another-workbook.html)

Jon C

Named Range in another workbook

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

Bernard Liengme

Feature
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Jon C

Figured so...! Thanks Bernard.

All times are GMT +1. The time now is 05:00 PM.