So in a different post earlier, the solution was the following formula:

=INDEX(Sunday!$A:$L,QUOTIENT(ROW(C13)-14,31)+3,COLUMN(C13)-3)

Can someone please explain to me what the red bold part means, so that I can adapt it to the workbook I am currently working on?



Please and thank you!

Have you also posted this on 5 other forums ?
Then please add links as cross posting etiquette requires
A message to forum cross posters - Excelguru
Thanks

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

This post is asking to define what's highlighted. My other posts that are all linked properly are asking for solutions on how to achieve what I need. And for the record, I thought it worked but it didn't. Further down the copy down, I found duplicates and errors. So I am back to square one.

COLUMN(C13) returns the column number of cell C13, which is 3. Subtracting 3 from that gives you 0 and passing 0 as the column argument to INDEX gives you all the columns of the relevant row.

The QUOTIENT function returns the integer part of a division, ignoring any remainder. SO that part is taking the row number, subtracting 14, dividing by 31 and keeping the integer part. You then add 3 so the result here will never be less than 3.
Other than the first block of 3s, you will get blocks of 31 of the same number - i.e. 31 4s followed by 31 5s and so on.