In a given sheet, if you have a formula that involves a value, it's possible to fix either the column or row for that value as you expand the equation, i.e. :
=A1 + A!2
But how do you do this when one of those values is from another sheet? You'd think it would be something like:
=A1 + 'OtherSheet'!A!2
but this doesn't work. Any thoughts?