In cell T34 of my first sheet, i want to reference cell AG84 from a second sheet, and from there copy the formula down on the first sheet so the results would display reesults from AG88, AG92 ...every 4th cell from the second sheet.
I have tried the following index formula, and have had no luck;
=INDEX('Savings Sheet'!$AG:$AG,4*(ROWS('Savings Sheet'!AG84)-1)+1)
I searched and that's where I came up with the index formula. I'm sure I just have it set up wrong though.
Bookmarks