Forum Discussion
jamellsatchell
Sep 11, 2022Copper Contributor
Microsoft Excel for Mac not updating formula when dragging to different cell
So I am attempting to drag a formula =Event!B$12. However when dragging with shift, option, or control the formula does not update to =Event!C$12. Please advise on how this can address this issue. ...
Riny_van_Eekelen
Platinum Contributor
jamellsatchell Don't use shift-option or ctrl at all. Have you tried hovering over the bottom right-hand corner of the cell (the little square)? Then click and drag.
jamellsatchell
Sep 11, 2022Copper Contributor
- HansVogelaarSep 11, 2022MVP
In your video, you drag down. The column letter won't change from B to C when you do that.
In the formula =Expense!B$11, the row reference is absolute, so the row number will remain 11 when you drag down.
Try a formula such as
=INDEX(Expense!$11:$11, COLUMN()-15)
in G26, then drag down.
- jamellsatchellSep 13, 2022Copper Contributor
HansVogelaar Thank you for the feedback. I am getting a value error. Not sure if it is being returned due to the Column().
- HansVogelaarSep 13, 2022MVP