Hi All
I am trying write an index formula that references the sheet names.
=INDEX('230701'!$B$6:$Z$30,MATCH(Upload!C2,'230701'!$B$6:$B$30,0),MATCH(I2,'230701'!$B$6:$Z$6,0))
The above formula works ... just a simple index match formula looking up some data in tab '230701'
However I want don't want to manually reference the cell but use a formula. So I tried the below formula .. where A3 is 230701 (General format)
INDEX("'"&A3&"'"!$B$6:$Z$30,MATCH($C3,"'"&A3&"'"!$B$6:$B$30,0),MATCH($I3,"'"&A3&"'"!$B$6:$Z$6,0))
However it does not work ... can anyone shed some light as to what I am doing wrong ??
TIA
I am trying write an index formula that references the sheet names.
=INDEX('230701'!$B$6:$Z$30,MATCH(Upload!C2,'230701'!$B$6:$B$30,0),MATCH(I2,'230701'!$B$6:$Z$6,0))
The above formula works ... just a simple index match formula looking up some data in tab '230701'
However I want don't want to manually reference the cell but use a formula. So I tried the below formula .. where A3 is 230701 (General format)
INDEX("'"&A3&"'"!$B$6:$Z$30,MATCH($C3,"'"&A3&"'"!$B$6:$B$30,0),MATCH($I3,"'"&A3&"'"!$B$6:$Z$6,0))
However it does not work ... can anyone shed some light as to what I am doing wrong ??
TIA