Hello guys,
How do I use an indirect formula to achieve the value which is currently in cell A2 of sheet named "Source" to that of A2 of sheet named "Destination"
If I had to achieve this without an indirect formula then I would simply type in "=Source!A2" inside cell "A2" of Sheet named "Destination"
This will allow me to link whatever value is in A2.
I have a helper cell A1 = Source for indirect referencing
plus I am guessing to use row() and column () formula but am unable to bring it into a working solution. as column() formula will output a column number and not the column's alphabet.
So far I tried something like this =INDIRECT(COLUMN()&ROW()) but obviously this will not work.
Will appreciate any help regarding this please.
Thanks.
How do I use an indirect formula to achieve the value which is currently in cell A2 of sheet named "Source" to that of A2 of sheet named "Destination"
If I had to achieve this without an indirect formula then I would simply type in "=Source!A2" inside cell "A2" of Sheet named "Destination"
This will allow me to link whatever value is in A2.
I have a helper cell A1 = Source for indirect referencing
plus I am guessing to use row() and column () formula but am unable to bring it into a working solution. as column() formula will output a column number and not the column's alphabet.
So far I tried something like this =INDIRECT(COLUMN()&ROW()) but obviously this will not work.
Will appreciate any help regarding this please.
Thanks.