is there a way to reference a cell, then just reference that cell +3 column?

[imthedan]

On one sheet, I have data at C19, C20 and C21. I want to be able to just pull down the formula so that it'll automatically show the data from the same cells, but 3 columns over... so, for example.

C19, C20, C21
F19, F20, F21
I19, I20, I21
L19, L20, L21

I want to be able to copy down a list that I have set up that'll reference those cells on another sheet. The data is on a sheet named Games.

Thanks!

 

[Max1616]

Try this:
=INDIRECT("Games!"&"R"&COLUMN(A1)-COLUMN($A$1)+19&"C"&((ROW(A1)-ROW($A$1)+1)*3),FALSE)

 

[imthedan]

Worked like a champ. Thanks man!