Looping after every 121 cells

[excelhelpneeds]

Hello,

I have to manually drag my formula for 121 cells and then change the formula by next column and/or row number.

Currently the 2 formulas I have are:

=IF(AND($Z$4>="", $AA$4>=""),H$6,J2456)

=OFFSET(X$5,0,(ROWS($1:1)-1)*2)

After every 121 cells that I drag these formulas to, in the first formula I change from H$7 to H$7 then H$7 then H$7 and so on

In the second formula, I change from X$5 to X$6 then X$7 then X$8 and so on.And also change the ROWS from 1:121 back to 1:1

Is there a formula which I can drag and it automatically changes the column and cell reference in the 2 formulas?