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

=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

I think you need to do this:

=INDIRECT("'06 07 rnl("&A5&")'!$C$4")

Hope this helps.

Pete


On Jan 30, 12:28 am, 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

Thanks Guys...

Cheers

"Pete_UK" wrote:

I think you need to do this:

=INDIRECT("'06 07 rnl("&A5&")'!$C$4")

Hope this helps.

Pete


On Jan 30, 12:28 am, 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