如何不用lookup，匹配出整行数据

zuodinia

我想按L列和M列，把旧表的数据匹配到N~S列。但不想用xlooup和VLOOKUP把N~S列都填上公式，请问有更好办法吗？

gadxjyang

=FILTER($C$3:$H$9,(A$3:$A$9=L3)*(B$3:$B$9=M3))

袁勇

1. =SUMIFS(C:C,$A:$A,$L3,$B:$B,$M3)

复制代码

zwzc

=FILTER($C$3:$H$9,$A$3:$A$9&$B$3:$B$9=L3&M3)

waternew

=INDEX($C$3:$H$9,SUM(IF(ISNUMBER(FIND(L3,$A$3:$A$9)*FIND(M3,$B$3:$B$9)),ROW($1:$7))),)

hxj119

1. =INDEX($C$3:$H$9,MATCH(L3&M3,$A$3:$A$9&$B$3:$B$9,0),)

复制代码

mykitami

=SUMIFS(C:C,$A:$A,$L3,$B:$B,$M3)

你是那块小饼干

1. =INDEX($C$3:$H$9,MATCH($L3&$M3,$A$3:$A$9&$B$3:$B$9,0),MATCH(N$2,$C$2:$H$2,0))

复制代码

tmplinshi

1. =XLOOKUP(L3&M3,$A$3:$A$9&$B$3:$B$9,$C$3:$H$9)

复制代码