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