Dynamic Sheet Name

[borabora12]

=INDEX('ONE'!$A:$A, 1, 1)

The above formula is getting the index array from sheet ONE. In cell N1 of the current sheet I have the name of the sheet I want to use.

So N1 = "ONE"

and I'm trying to do this:

=INDEX('N1'!$A:$A, 1, 1)

Hope it makes sense what I am trying to accomplish. Thanks in advance.

 

[njimack]

=INDEX(INDIRECT(N1&"!$A:$A"), 1, 1)
or
=INDEX(INDIRECT(ADDRESS(1,1,,,N1)), 1, 1)

 

[Aladin Akyurek]

=INDEX('ONE'!$A:$A, 1, 1)

The above formula is getting the index array from sheet ONE. In cell N1 of the current sheet I have the name of the sheet I want to use.

So N1 = "ONE"

and I'm trying to do this:

=INDEX('N1'!$A:$A, 1, 1)

Hope it makes sense what I am trying to accomplish. Thanks in advance.

Try...

=INDEX(INDIRECT("'"&N1&"'!A:A"),1,1)