Indirect Formula Problem
=INDIRECT("'06 07rnl(" & A5 & ")'!C4")
--
Gary's Student
gsnu200703
"sid@knee" wrote:
Hi,
I'm having trouble using the INDIRECT formula below
=INDIRECT("'06 07 rnl(&A5&)'!$C$4")
It returns a reference problem.
A5 is the cell worksheet number, there are multiple worksheets named 06 07
rnl (#) where # can be any number from 1-115.
Any suggestions on how to fix this?
Cheers
|