Oct 01 2020 11:09 AM
Is there a formula that will populate every other cell while keeping the letter the same but adding 19 as we go along. (Example=J2 then the next cell along would be J19)
I'm lifting the values from another page where the values are in column form.
Oct 01 2020 11:22 AM
You want to link/lookup a value on another worksheet, but each formula row should increment 19 rows on the target/source worksheet?
Attached is an example that I think will help. I wasn't sure exactly where you wanted the formula to appear and from where it should pull, so change range references to suit. Basically, you use the ROWS function to create a counter {0,1,2,3,4...} that is multiplied by 19.