I'm having an issue trying to logic out how to create a looping reference for an INDEX or MATCH formula. What I require is for AR3 and down to represent the index location of S2 and down. I need AR to cycle through that index n number of times where n is the value in the Y column associated the index in Y and then increment into the next index. I can not do this with VBA due to organization restrictions and I really want to keep this with formulas and helper cells, no power query. Any advice is appreciated.