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
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

@NickNgolo ,

 

Hi, that could be

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

in A2 to drag it down

 

@Sergei Baklan solution works fine. Thanks!!!

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies