Forum Discussion
Formulas and Functions
Hi, I have a formula ='Child 40' !$V$38. I need to copy formula down for another 40 cells but change the child number each time in sequence keeping same cell reference, I'm stuck on how to do it.
=INDIRECT(ADDRESS(38,22,,,"Child "&ROW(A40)))
This returns the expected result in my sheet.