March 28, 2019
Suppose the numbers in my excel sheet is coming from another excel sheet within the same workbook, then the numbers are linked with another sheet numbers. It has a link as "='Hyperion - Jan'!$Z$54" in formula bar which has a value of 32.8%.
Now I need to change this $Z$54 cell reference n number of times in various cells, so i was trying to insert this $Z$54 in my formula through the formula if Z & 54 is written in my excel in other cells for the reference. But i was stuck & not able to come up with the formula i want.
October 5, 2010
June 25, 2016
Are you referring to the INDIRECT function?
E.g. in cell A1 you have the text $Z$54. You can use INDIRECT($A$1) in all your formulas to reference the cell $Z$54.
If you decide to change the reference in A1 to $X$10 (for example) then the INDIRECT($A$1) will now reference cell $X$10.