求助OFFSET+MATCH+FILTER

438515092

求助OFFSET+MATCH+FILTER   相当于下移{1,2,3,4}

苏Lang

1. =XLOOKUP($P$2&$P3,$A:$A&$B:$B,OFFSET($B:$B,,COLUMN(A1)),"")

复制代码

我的城市你来过

=OFFSET($A$2,MATCH($P$2&$P3,$A$2:$A$8&$B$2:$B$8,)-1,MATCH(R$2,$A$2:$N$2,)-1)

丢丢表格

=N(OFFSET(C$2,IFERROR(MATCH(FILTER($B$3:$B$8,$A$3:$A$8=$P$2),$B$3:$B$8,0),""),,))

quqiyuan

=OFFSET($C$2:$N$2,MATCH($P3&$P$2,$B:$B&$A:$A,)-2,)

象山海鲜

去掉下移列 直接用筛选

1. =FILTER($B$3:$N$8,$A$3:$A$8=$P$2)

复制代码