Named Range in 3-D Formula

"=?Utf-8?B?RWQgUmVhcmRvbg==?=" wrote...
I have need to insert a named range into a 3-D formula such as this:

='C:\Work\[DataFile.xls]Sheet1'!$A$1

replacing the column reference "A" with a named range (let's call
it "NewColumn") that has a value for a new column reference, i.e. "B".
...

This can't be done directly. If the other workbook would be open, you could use
the INDIRECT function.

=INDIRECT("'[DataFile.xls]Sheet1'!"&NewColumn&"1")

If the other workbook could be closed, then see

http://www.google.com/groups?selm=zK...wsrange r.com

--
To top-post is human, to bottom-post and snip is sublime.

"=?Utf-8?B?RWQgUmVhcmRvbg==?=" wrote...
Thank you for your response and information; using the INDIRECT function will
now allow the use of a named range in place of a column reference in my
formulas.

As long as the workbooks to which you're referring are open, yes. Otherwise, no.

Since I have multiple files of considerable size that will need to be opened
for INDIRECT to work appropriately, I will use INDIRECT in conjuntion with VB
coding to achieve the final desired results.
...

If you're going to use VBA anyway, you'd be better off using it to enter literal
external link references in cell formulas than using it to enter formulas using
INDIRECT to construct such references.

--
To top-post is human, to bottom-post and snip is sublime.