Referencing Defined Name in another workbook

Posted to microsoft.public.excel.programming

Raj[_2_]

external usenet poster

Posts: 150

Referencing Defined Name in another workbook

For a vlookup function, I need to reference a name in another
workbook,
If the workbook is "Source Data.xls" and the Defined name in that
workbook is "lookuprange" then what will the second argument in the
formula below (in another workbook) be

=vlookup(b2,second argument,3,false)

Thanks in Advance for the help.

Regards,
Raj

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Referencing Defined Names in Other Workbooks	wx4usa	Excel Discussion (Misc queries)	4	August 24th 12 05:21 PM
Exceeding 65K of defined names within workbook causes workbook to go into repair mode when it is opened	Ronald Dodge[_2_]	Excel Programming	13	May 18th 07 02:24 PM
copying worksheets to a new workbook without formulae referencing original workbook	[email protected]	Excel Programming	2	October 16th 06 07:31 PM
Referencing defined range	spartanmba	Excel Discussion (Misc queries)	2	September 14th 05 01:28 AM
Referencing a Defined Name	Patrick Simonds	Excel Programming	2	December 24th 04 11:24 PM

All times are GMT +1. The time now is 06:37 AM.

Menu

About Us