Forum Discussion

NickNgolo's avatar
NickNgolo
Copper Contributor
May 30, 2019

Drag down a formula while incrementing the column reference

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      ...
Excel
SergeiBaklan's avatar
SergeiBaklan
MVP

NickNgolo ,

 

Hi, that could be

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

in A2 to drag it down

 

NickNgolo's avatar
NickNgolo
Copper Contributor
May 31, 2019

SergeiBaklan solution works fine. Thanks!!!

Resources