INDIRECT.EXT

R

rrousseau

I just downloaded this function and am having trouble getting it to
work.
When I enter the reference value in the function formula dialog box,
the reference evaluates correctly to the contents of the cell in the
closed worksheet. Yet when I close the function dialog box, the cell
in my spreadsheet says "#REF". I have tried all combinations of the
remaining parameters, but nothing returns to my spreadsheet excep
"#REF".

This is what I have in the formula:
=INDIRECT.EXT('\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38,TRUE)
 
R

Ron Rosenfeld

=INDIRECT.EXT('\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38,TRUE)

Try this:

=INDIRECT.EXT("'\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38",TRUE)

--ron
 
R

rrousseau

=INDIRECT.EXT('\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38,TRUE)

Try this:

=INDIRECT.EXT("'\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38",TRUE)

--ron

Thank You! That does it.
 
R

Ron Rosenfeld

=INDIRECT.EXT('\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38,TRUE)

Try this:

=INDIRECT.EXT("'\\fhserver1\data\Finance\Project ETCs\ETC New Form\ETC
\6170\[63.xls]ETC'!$E$38",TRUE)

--ron

Thank You! That does it.

Good to hear. Thanks for the feedback. For lurkers, the argument to INDIRECT
needs to be a string so, unless it is in a text cell, needs to be enclosed
between quote marks (" ").

By the way, the TRUE argument is superfluous, as that is the default.
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top