Sequential Sheet References

Jack Karrde 0
Viewed 24

I'm trying to create a calendar that references specific cells from another sheet. For example, the first calendar entry is Sheet1!$A$3.

I need the next reference to be 4 cells down from the previous (Sheet1!$A$7), and so on (next being Sheet1!$A$7).

Is there a formula that will check the previous cell reference and return the value 4 cells below the previous?

reference excel-formula cell excel
1 Answers

If you are on Microsoft-365 then can try-

=INDEX(Sheet1!A:A,SEQUENCE(10,1,3,4))

Otherwise can try-

=INDEX(Sheet1!A:A,(ROW(1:1)*4)-1)
Harun24hr0
Related