1

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..... – Jacob Jan Tuinstra Mar 24 '14 at 13:16
  • Oh man... yea. (facepalm) – Peter Berg Mar 24 '14 at 21:47
2

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, privacy policy and cookie policy

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