0

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")}

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged or ask your own question.