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.
Forum Discussion
=INDIRECT(ADDRESS(38,22,,,"Child "&ROW(A40)))
This returns the expected result in my sheet.
