问题:多对一查找
函数解决:
=FILTER(C:C,(A:A=F2)*(B:B=G2),0) =XLOOKUP(F2&G2,A:A&B:B,C:C,0) {=IFERROR(INDEX(C:C,MATCH(F2&G2,A:A&B:B,)),)}
officeplayer 2022-05-14 19:49 原文
问题:多对一查找
函数解决:
=FILTER(C:C,(A:A=F2)*(B:B=G2),0) =XLOOKUP(F2&G2,A:A&B:B,C:C,0) {=IFERROR(INDEX(C:C,MATCH(F2&G2,A:A&B:B,)),)}