Sep 11 2022 12:05 PM
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. It just recently starting occuring.
Sep 11 2022 12:32 PM
@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.
Sep 11 2022 12:55 PM - edited Sep 11 2022 01:01 PM
Sep 11 2022 02:54 PM
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.
Sep 12 2022 09:14 PM
@HansVogelaar Thank you for the feedback. I am getting a value error. Not sure if it is being returned due to the Column().
Sep 13 2022 12:17 AM