=LET(a,REGEXEXTRACT($F$2:$F$14,"[0-9]"),b,IF(a="5",a*10,a*100),c,SCAN(,$E$2:$E$14,LAMBDA(V,y,IF(y="",V,y))),d,HSTACK(c,b,$G$2:$G$14),e,IFS(OR(A2="M",A2="L"),FILTER(d,c="M/L"),AND(LEFT(A2,1)<>"5",RIGHT(A2,2)="XL"),FILTER(d,c="XL-4XL",),LEFT(A2,1)="5",FILTER(d,c="5XL",),LEFT(A2,1)="S",FILTER(d,c="S",)),f,TAKE(e,,-2),g,XLOOKUP(B2,TAKE(f,,1),TAKE(f,,-1),,-1),g)
