first column,then row
=OFFSET($A$1,COLUMN(A1)-1+(ROW(A1)-1)*4,)
first row then column
=OFFSET($A$1,ROW(A1)-1+COLUMN(A1)*4-4,)

Just another WordPress site
first column,then row
=OFFSET($A$1,COLUMN(A1)-1+(ROW(A1)-1)*4,)
first row then column
=OFFSET($A$1,ROW(A1)-1+COLUMN(A1)*4-4,)