怎么多条件匹配？

cxwhite

怎么三个条件匹配啊？

求助求助！！！！！

hugeinfo

=FILTER(OFFSET(A1,3,MATCH(N12,3:3,)-1,47),ISNUMBER(VDB(,,SCAN("",B4:B50,LAMBDA(x,y,IF(y<>"",y,x))),SCAN("",A4:A50,LAMBDA(x,y,IF(y<>"",y,x))),L12))*(C4:C50=M12))

袁勇

1. =SUMPRODUCT((LOOKUP(ROW(4:50),ROW(4:50)/(A4:A50<>""),A4:A50)<L12)*(C4:C50=M12)*(D3:J3=N12)*D4:J50)

复制代码

jerrike

1. =XLOOKUP(LOOKUP(L12,$A$4:$A$50)&M12,SCAN(,A4:A50,LAMBDA(a,b,IF(b="",a,b)))&C4:C50,XLOOKUP(N12,D3:J3,D4:J50))

复制代码

gadxjyang

=OFFSET(C1,MATCH(1=1,(IF(C4:C50=M12,ROW(4:50),-51)-MATCH(1=1,B4:B49>=L12,)-3)>=0,)+2,MATCH(N12,D3:J3,))

uug

参考
=VLOOKUP(M12,OFFSET(A1,MATCH(LOOKUP(L12,A4:A50),A1:A50,)-1,2,10,8),MATCH(N12,C3:J3,),)

我要成为专家

1. =LET(s,SCAN(,A4:A50,LAMBDA(x,y,IF(y=0,x,y))),p,SCAN(,B4:B50,LAMBDA(x,y,IF(y=0,x,y))),MAX((s<L12)*(p>=L12)*(C4:C50=M12)*(D3:J3=N12)*D4:J50))

复制代码

yllmessi

=LET(A,SCAN("",A4:A50,LAMBDA(x,y,IF(y="",x,y))),SUM(CHOOSEROWS((M12=C4:C50)*(N12=D3:J3)*D4:J50,FILTER(ROW(C4:C50),LOOKUP(L12,A)=A)-3)))

cxwhite

hugeinfo 发表于 2024-11-27 17:11
=FILTER(OFFSET(A1,3,MATCH(N12,3:3,)-1,47),ISNUMBER(VDB(,,SCAN("",B4:B50,LAMBDA(x,y,IF(y"",y,x))),SCA ...

当前所使用的函数无效

cxwhite

袁勇 发表于 2024-11-27 17:12

尝试换了一下数值，出来的结果对不上