formula to copy cells with a repeating pattern

I am trying to find a formula for the following:
I am creating a dashboard view of a spreadsheet.
In column F from F22 to F93, each cell needs to show a dollar amount.
These dollar amounts begin in I163 and repeat every 54 cells until I3997
Is there a formula I can use in F22 that can be copied down to F93. Currently I am writting into each cell F22 =I163, F23=I217, F24=I271..... I have 8 other columns like this and it is very time consuming.

Try this in F22 and drag across:

=INDEX($I$109:$I$3997,COLUMNS($F22:F22)*54,1)

Doesn't seem to work. when I open the cell formulas it highlights the column where the information is, but doesn't populate the cells.

Can you upload a sample file (with any personal/sensitive data removed)?

Oops. My bad - change the 109 to 110

That worked to a point, but it only picked up the first value and carried that down the column.

I uploaded the file. Take a look at it. Maybe I am doing something wrong.

Thanks! Works like a charm.

You're welcome. Don't forget to mark your thread as SOLVED (if needed, click on the FAQ button at top of forum page to see directions).