can i get help with indirect formula

  • Thread starter Thread starter Gary Keramidas
  • Start date Start date
G

Gary Keramidas

let's say i have this formula which works

='N:\My Documents\Excel\Test.xls'!Feb_Profit

if Test is in c1, how would i write the formula using indirect?

i tried
=INDIRECT("'N:\My Documents\' "& C1 & ".xls'!Feb_Profit")
and
=INDIRECT("'N:\My Documents\Excel\"& C1 & ".xls'!Feb_Profit")

but get a ref error
 
You wouldn't because, as it explains in help on INDIRECT, INDIRECT does not
work with links to closed workbooks.
 
ok, thanks, that explains it

--


Gary


Tom Ogilvy said:
You wouldn't because, as it explains in help on INDIRECT, INDIRECT does not
work with links to closed workbooks.
Click to expand...
 

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

Similar Threads

Indirect formula errors if file is closed 1
Array Formula In IF Function 0
VLookup and Indirect 3
Transpose Indirect formula 2
Excel sum if and closed workbooks 2
Using the INDIRECT function across multiple worksheets 1
INDIRECT Syntax 1
Issue with INDIRECT function. 4

Back
Top