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?

  • Try using a $ in stead of a ! for the second exclamation mark..... Mar 24, 2014 at 13:16
  • Oh man... yea. (facepalm)
    – Peter Berg
    Mar 24, 2014 at 21:47

1 Answer 1


You only use the exclamation point following the sheet name, not the cell -

=A1 + 'Other Sheet'!A$2

Use dollar signs for absolute references.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.