can i get help with indirect formula
ok, thanks, that explains it
--
Gary
"Tom Ogilvy" wrote in message
...
You wouldn't because, as it explains in help on INDIRECT, INDIRECT does not
work with links to closed workbooks.
--
Regards,
Tom Ogilvy
"Gary Keramidas" wrote:
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
--
Gary
|