Copy Down formula plus 3 cols

[Gusher]

Hi,

In cell A1 I have =FZ33 so returns the contents of cell FZ33. In cell A2 I have =GC33. In Cell A3 I have =GF33. SO what is happening here is I am reporting the contents of row 33 every three columns. I want a formual that I can copy down in col A. So if I copy the formula in Cell A3 to A4 it will report the contents of cell GI33 and so on copying down col A. Many Thanks

 

[MARK858]

Maybe in A1...

=INDIRECT(ADDRESS(33,179+ROW($B1)*3))

and drag down

 

[Gusher]

Many thanks Mark that worked !

 

[MARK858]

You're welcome, if there is ever the chance that you will need to delete any rows then use the formula below as it is a bit more robust

=INDIRECT(ADDRESS(33,179+ROWS($B$1:$B1)*3))