Home

Drag down a formula while incrementing the column reference

%3CLINGO-SUB%20id%3D%22lingo-sub-657541%22%20slang%3D%22en-US%22%3EDrag%20down%20a%20formula%20while%20incrementing%20the%20column%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-657541%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EKindly%20assist%20me%20do%20this%20simple%20formula.%3C%2FP%3E%3CP%3EI%20wish%20to%20drag%20down%20a%20formula%20while%20incrementing%20the%20column%20reference%20as%20in%20below%20example%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%20in%20cell%20A2%20is%26nbsp%3B%3D%3CSTRONG%3EE2-'Project%20Dispatch'!G4%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BA3%20is%3CSTRONG%3E%26nbsp%3B%3DE3-'Project%20Dispatch'!H4%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BA4%20is%3CSTRONG%3E%26nbsp%3B%3DE4-'Project%20Dispatch'!I4%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-657541%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-657561%22%20slang%3D%22en-US%22%3ERe%3A%20Drag%20down%20a%20formula%20while%20incrementing%20the%20column%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-657561%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351746%22%20target%3D%22_blank%22%3E%40NickNgolo%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHi%2C%20that%20could%20be%3C%2FP%3E%0A%3CPRE%3E%3D%24E2-INDEX('Project%20Dispatch'!%244%3A%244%2CROW()%2B5)%3C%2FPRE%3E%0A%3CP%3Ein%20A2%20to%20drag%20it%20down%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-660615%22%20slang%3D%22en-US%22%3ERe%3A%20Drag%20down%20a%20formula%20while%20incrementing%20the%20column%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-660615%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3Bsolution%20works%20fine.%20Thanks!!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-661767%22%20slang%3D%22en-US%22%3ERe%3A%20Drag%20down%20a%20formula%20while%20incrementing%20the%20column%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661767%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F351746%22%20target%3D%22_blank%22%3E%40NickNgolo%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
NickNgolo
New Contributor

Hi All,

Kindly assist me do this simple formula.

I wish to drag down a formula while incrementing the column reference as in below example

 

Formula in cell A2 is =E2-'Project Dispatch'!G4

                         A3 is =E3-'Project Dispatch'!H4

                         A4 is =E4-'Project Dispatch'!I4

 

 

3 Replies
Highlighted

@NickNgolo ,

 

Hi, that could be

=$E2-INDEX('Project Dispatch'!$4:$4,ROW()+5)

in A2 to drag it down

 

Highlighted

@Sergei Baklan solution works fine. Thanks!!!

Highlighted