Formulas do not act like I want when copied. These formulas work but when copied do not increment the way I need. As you can see I need the `ROW(20:20)`

to increase by 1 to `ROW(21:21)`

in the next cell, then by 8 to `ROW(29:29)`

then by 1 then by 9 so on and so forth. Also I need the `MATCH(A5,`

to increase to A7 when the row increases by 8. Any help would be greatly appreciated. or if there is an easier way to do this... Thank you in advance.

```
{=IFERROR(INDEX(Sheet2!$A$1:$Z$500,SMALL(IF(MATCH(A5,Sheet2!A:A,0),ROW(Sheet2!$A$1:$Z$500)),ROW(20:20))-1,13),"Error")}
{=IFERROR(INDEX(Sheet2!$A$1:$Z$500,SMALL(IF(MATCH(A5,Sheet2!A:A,0),ROW(Sheet2!$A$1:$Z$500)),ROW(21:21))-1,13),"Error")}
{=IFERROR(INDEX(Sheet2!$A$1:$Z$500,SMALL(IF(MATCH(A7,Sheet2!A:A,0),ROW(Sheet2!$A$1:$Z$500)),ROW(29:29))-1,13),"Error")}
{=IFERROR(INDEX(Sheet2!$A$1:$Z$500,SMALL(IF(MATCH(A7,Sheet2!A:A,0),ROW(Sheet2!$A$1:$Z$500)),ROW(30:30))-1,13),"Error")}
```