Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this community
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?
You only use the exclamation point following the sheet name, not the cell -
=A1 + 'Other Sheet'!A$2
Use dollar signs for absolute references.
$in stead of a!for the second exclamation mark..... – Jacob Jan Tuinstra Mar 24 '14 at 13:16