| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Figured so...! Thanks Bernard.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you point to a named range in linked workbooks? | Excel Discussion (Misc queries) | |||
| Poor Workbook Performance due to Named Ranges | Excel Discussion (Misc queries) | |||
| named range refers to: in a chart | Excel Discussion (Misc queries) | |||
| Address of named range | Excel Worksheet Functions | |||
| Single quotes in named range | Excel Worksheet Functions | |||
Hybrid Mode
