多对一查找


问题:多对一查找

函数解决:

=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,)),)}

相关