Drag down a formula while incrementing the column reference

[NickNgolo]

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

[#2]

@NickNgolo ,

Hi, that could be

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

in A2 to drag it down

[#3]

@SergeiBaklan solution works fine. Thanks!!!

[#4]

@NickNgolo , you are welcome