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