Formula to refer to other visible sheet not static

[coreytroy]

Please Login or Register  to view this content.

I had a STATIC reference in the above formula to a sheet tab called '1050', as can b e seen above.

I have realised i need this not to refer to a specific sheet, but to what ever sheet is not hiden.

My sheet tab names are '900, 1000, 1050,1200,1500,1800 & 2000'.

And depending on other data factors, the above formula i need to reference the sheet tab required.
The other sheet to be referenced is ALWAYS the same as the current sheet C136 value, if that helps ?

How can i modify the formula to do this ?

[Ace_XL]

Use the INDIRECT function to refer to the desired tab. Try

Please Login or Register  to view this content.

Some reading here
www.cpearson.com/excel/indirect.htm