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 |