如何多列变序号查找填充

mykitami

=IFNA(INDEX(OFFSET($A$1:$A$9,,MATCH(B$11,$B$1:$G$1,)),MATCH($A12,$C$1:$C$9,)),"")

下拉，右拉

mykitami

=DROP(REDUCE("",A12:A16,LAMBDA(x,y,VSTACK(x,CHOOSECOLS(FILTER(A2:G9,C2:C9=y,EXPAND("",,7,"")),MATCH(B11:G11,A1:G1,))))),1)

quqiyuan

=OFFSET($A$1,MATCH($A12,$C$2:$C$9,),MATCH(B$11,$1:$1,)-1)

quqiyuan

或者
=XLOOKUP($A12,$C$2:$C$9,OFFSET($A$2:$A$9,,MATCH(B$11,$1:$1,)-1))

沈默00

   
=IFNA(OFFSET($A$1,MATCH($A12,$C$2:$C$9),MATCH(B$11,$A$1:$G$1,)-1,1),"")  右拉、下拉

jerrike

1. =CHOOSECOLS(FILTER(B$2:G$9,C$2:C$9=A12),MATCH(B$11:G$11,B$1:G$1,))

复制代码

华尔街操盘手

b12下拉

1. =XLOOKUP(A12,$C$2:$C$9,HSTACK($E$2:$E$9,$B$2:$B$9,$D$2:$D$9,$B$2:$B$9,$F$2:$F$9,$G$2:$G$9))

复制代码

wdy895

两个姓名是啥情况？

袁勇

=OFFSET($A$1,MATCH($A12,$C$2:$C$9,),MATCH(B$11,$A$1:$G$1,)-1)