=MATCH($A1,OFFSET($H1,COLUMNS($C1:C1)*8-8,0,4),0)
=MATCH($A1,INDEX($H:$H,COLUMNS($C1:C1)*8-7):INDEX($H:$H,COLUMNS($C1:C1)*8-4),0)
I don't think so - referencing D2 in a formula in D2 would cause a circular reference.so D2 should be
=MATCH($D2,sortuniques!$A$72:$A$90,0)
It is not clear whether they are formulas you have that are not working or formulas you want. Further, there is no indication of what cells they are or would be in.=MATCH($A2,sortuniques!$A$3:$A$21,0)
=MATCH($B2,sortuniques!$A$26:$A$44,0)
=MATCH($C2,sortuniques!$A$49:$A$67,0)
For the first 3 formulas above this is still the case:My error again.
=MATCH($A2,sortuniques!$A$3:$A$21,0)
=MATCH($A2,sortuniques!$A$26:$A$44,0)
=MATCH($A2,sortuniques!$A$49:$A$67,0)
so D2 should be
=MATCH($A2,sortuniques!$A$72:$A$90,0)
there is no indication of what cells they are or would be in
B2
use=IFERROR(MATCH($A2,INDEX(sortuniques!$A:$A,COLUMNS($B$1:B$1)*23-20):INDEX(sortuniques!$A:$A,COLUMNS($B$1:B$1)*23-2),0),"")
I suspect that you may well be right, but that doesn't get the D2 formula to be matching in rows 72:90 as indicated by the OP in posts 5 and 7. I am guessing that the OP is just not being careful enough with precise information which is why I was trying to press that point.In B2 use