I know there is a difference between relative and absolute references: if my cell A10 contains "=A8+A9" and I copy it to A20, it will become "=A18+A19". On the other hand if cell B10 contains "=B$8+B9" and I copy that to B20, it will become "=B$8+B19".
I.e. any row number starting with $ remains constant.
Now, is it also possible to express a relative row number independently of the row it's used in? I mean something like "=B(-1)" which would indicate "column B, one row above the current one" or "=C(+2)" meaning "column C, two rows below the current one".
Bookmarks