Looking up a range name

[Devilfish2006k]

I have a ranges on a worksheet called cTest, cTest2 and, cTest3

I want to do an index formula along the lines of Index(range,1,1)

I want the range to be flexible so that it can be cTest or cTest2 or cTest3. Is there a way to get the name range into the index formula?

Many thanks

 

[Devilfish2006k]

I want to avoid the speech marks in the formula.

Many thanks

 

[Sektor]

This?

=INDEX(cTest,1,1)
=INDEX(cTest2,1,1)
=INDEX(cTest3,1,1)

 

[Andrew Poulsom]

Say A1 contains the text cTest. Then you can use:

=INDEX(INDIRECT(A1),1,1)

and changing what's in A1 will change what the formula returns.