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

%3CLINGO-SUB%20id%3D%22lingo-sub-1736274%22%20slang%3D%22en-US%22%3EFormula%20to%20populate%20every%20other%20cell%20while%20adding%2019%20as%20we%20go%20along%20a%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1736274%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20formula%20that%20will%20populate%20every%20other%20cell%20while%20keeping%20the%20letter%20the%20same%20but%20adding%2019%20as%20we%20go%20along.%20(Example%3DJ2%20then%20the%20next%20cell%20along%20would%20be%20J19)%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20lifting%20the%20values%20from%20another%20page%20where%20the%20values%20are%20in%20column%20form.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1736274%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1736326%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20to%20populate%20every%20other%20cell%20while%20adding%2019%20as%20we%20go%20along%20a%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1736326%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F385033%22%20target%3D%22_blank%22%3E%4016Teams%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20want%20to%20link%2Flookup%20a%20value%20on%20another%20worksheet%2C%20but%20each%20formula%20row%20should%20increment%2019%20rows%20on%20the%20target%2Fsource%20worksheet%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20an%20example%20that%20I%20think%20will%20help.%20I%20wasn't%20sure%20exactly%20where%20you%20wanted%20the%20formula%20to%20appear%20and%20from%20where%20it%20should%20pull%2C%20so%20change%20range%20references%20to%20suit.%20Basically%2C%20you%20use%20the%20ROWS%20function%20to%20create%20a%20counter%20%7B0%2C1%2C2%2C3%2C4...%7D%20that%20is%20multiplied%20by%2019.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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.