detect the 10 triplets in the 5 positions .

[jorel]

detect the 10 triplets in the 5 positions
goal = positionally locate the 10 trios in the 5 positions of the 80-5 draw
https://www.excelforum.com/attachmen...1&d=1643302402

[MrShorty]

It looks like it should be a simple lookup function. Use row 5 as a lookup value, then return the corresponding cell from the current row. I would probably prefer INDEX() MATCH() for this. In order to avoid unnecessary duplication of the slow lookup step, I would probably put the MATCH() functions in a helper row:

1) In G4, enter =MATCH(G5,$A$5:$E$5,0) and copy/paste/fill across row 4. Note the mix of relative and absolute references for easy copying.
2) In G6, enter =INDEX($A6:$E6,G$4) and copy/paste/fill down and across as far as needed. Again, note the mix of relative and absolute references.

Does that work for you?