entire_world
New Member
- Joined
- Dec 10, 2017
- Messages
- 1
Hi
I used to have trouble in making the indirect formula updating the reference cells every time I drag it. For example I put A1 in the indirect formula and I hope the reference cell can change accordingly to A2 when I drag the cell down.
The problem is now solved with formula =INDIRECT("'"&Sheet name&"'!"&CELL("ADDRESS",A1))
However, new problem has occurred as the reference cell will change randomly everytime I hit F9 to refresh my sheet. For example, the reference cell initially linked through the indirect function is A1, once I have to hit F9 to refresh my sheet, A1 will change to H1 or B1. This is troublesome as I had to adjust the formula so that it is re-linked back to A1 and vice versa for the formulas in other cells.
Have anyone come across a similar problem as mine? Please help with this !
I used to have trouble in making the indirect formula updating the reference cells every time I drag it. For example I put A1 in the indirect formula and I hope the reference cell can change accordingly to A2 when I drag the cell down.
The problem is now solved with formula =INDIRECT("'"&Sheet name&"'!"&CELL("ADDRESS",A1))
However, new problem has occurred as the reference cell will change randomly everytime I hit F9 to refresh my sheet. For example, the reference cell initially linked through the indirect function is A1, once I have to hit F9 to refresh my sheet, A1 will change to H1 or B1. This is troublesome as I had to adjust the formula so that it is re-linked back to A1 and vice versa for the formulas in other cells.
Have anyone come across a similar problem as mine? Please help with this !