Jun 16 2021 02:11 PM
Hi There, Trying to create a formula for this instead of manually typing it every time. If I use the "fill" option, it increases the wrong number. I need the first number to increase and the second number to stay constant. Does anyone know how to do this?!
='CO 1'!C17
='CO 2'!C17
='CO 3'!C17
='CO 4'!C17
='CO 5'!C17
Jun 16 2021 02:16 PM
You can use the INDIRECT function for this.
Let's say that the first formula is in a cell in row 1. Change it to
=INDIRECT("'CO "&ROW()&"'C17")
And if the formula is in (for example) a cell in row 4, it becomes
=INDIRECT("'CO "&ROW()-3&"'C17")
Jun 16 2021 02:35 PM
Jun 16 2021 02:56 PM
Please look at my previous reply again. The "1", "2", "3" etc. are NOT part of the formula that I posted.