Forum Discussion
Formula to populate every other cell while adding 19 as we go along a row
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.
1 Reply
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.
