Formula to populate every other cell while adding 19 as we go along a row

Copper Contributor

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

@16Teams 

 

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.