
New Member

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.

VIP

Trusted Members

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.
1 Guest(s)
