Use a range value in place of sheet name
 

Tried searching for this but I guess I'm using the wrong criteria (or just
having a brain fart).

I have a formula that gets a value from a particular sheet:
=Names!H35

What I want to do is substitute the sheet name for what's in a named range.
i'e. I have a sheet named "XXX"
I have a range named "LastSheet"
The value of "LastSheet" is "XXX"

How do I modify my original formula to use "LastSheet" to get whatever
is in H35 on Sheet "XXX" ?

Thanks,
John

Use a range value in place of sheet name
 

Use the INDIRECT function.
--
David Biddulph

"John Wilson" wrote in message
...
Tried searching for this but I guess I'm using the wrong criteria (or just
having a brain fart).

I have a formula that gets a value from a particular sheet:
=Names!H35

What I want to do is substitute the sheet name for what's in a named
range.
i'e. I have a sheet named "XXX"
I have a range named "LastSheet"
The value of "LastSheet" is "XXX"

How do I modify my original formula to use "LastSheet" to get whatever
is in H35 on Sheet "XXX" ?

Thanks,
John