reference to other sheet as a string

[miri tz.]

Hi, I need to use the following formula =OFFSET('HW - TCO'!B7,0,-1)
HW - TCO is reference to another sheet in my excel. the name of the sheet is
actually string which should be manipulate forexample : HW appears under cell
A1...TCO is a result of other string manipulating. but when i try to write
the formula: =offset(' ... and then "range("a1")&... it always fell!!!
i need help! thanks

 

[Dave Peterson]

=offset(indirect("'" & $a$1 & " - " & yourTCOFormula & "'!b7"), 0, -1)