Drag down a formula while incrementing the column reference

Question

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&nbsp;Formula in cell A2 is&nbsp;=E2-'Project Dispatch'!G4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A3 is&nbsp;=E3-'Project Dispatch'!H4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A4 is&nbsp;=E4-'Project Dispatch'!I4&nbsp;&nbsp;

sergeibaklan · Answer

NickNgolo&nbsp;,
&nbsp;
Hi, that could be
=$E2-INDEX('Project Dispatch'!$4:$4,ROW()+5)
in A2 to drag it down
&nbsp;

nickngolo · Answer

SergeiBaklan&nbsp;solution works fine. Thanks!!!

sergeibaklan · Answer

NickNgolo&nbsp;, you are welcome

Forum Discussion

Drag down a formula while incrementing the column reference

3 Replies

Resources