I have the following formula which is giving me the #REF! error.
If I make the last reference a label it works but by making it a real
reference the formula dies. What am I doing wrong.
Thanks

=INDIRECT("'"&$a8&"'"!"&D$89) doesn't work
=INDIRECT("'"&$a8&"'"!"&"D$89") works but now I can't copy the formula to
use relative addresses.

=indirect(("'"&$a8&"'"!" this part works and is referencing a sheet within
a work
&D$89 this part does not. I am trying to reference a cell location in the
referenced sheet )
I want to be able to copy the formula to give me the relative reference in
the other sheet.





--
Tom