Dynamic Tab name instead of fixed

[coreytroy]

Please Login or Register  to view this content.

I have the above formual in a cell, with a ref to a sheet tab named '1050'.

Now i need to have the same formula, but have it changed to the tab name that is selected in cell C136 of the activesheet.

IE. '1050' sheet tabe in the above example is an actual value selected in C136.

If i change the C136 value to say 2000, then the fomula needs to refelect '2000'E33<> etc instead of '1050'.

How can i do this ?

[JieJenn]

try indirect to reference
=IF(Indirect($C$136) &"!"&E33<>A14,"",TRUE)

[benishiryo]

hi coreytroy, try:
=IF(INDIRECT("'"&C136&"'!E33")<>A14,"",TRUE)

[coreytroy]

Perfect, Thanks guys !