根据条件，输出结果

Tongbaby2020

根据条件，输出结果，
但是用：{IF(A2:A21=H3,IF(B2:B21=I3,IF(C2:C21=J3,D2:D21)))}  这样做没有用，帮忙看看，谢谢！

高个子

1. =XLOOKUP($H3&$I3&$J3,$A$2:$A$21&$B$2:$B$21&$C$2:$C$21,D2:D21)

复制代码

niko88819

K3

1. =FILTER(FILTER(A2:F21,(A2:A21=H3)*(B2:B21=I3)*(C2:C21=J3)),{0,0,0,1,1,1})

复制代码

solextrade

=LOOKUP(1,0/($A2:$A21=$H3)/($B2:$B21=$I3)/($C2:$C21=$J3),D2:D21)

橒♂蝣

=FILTER(D2:F21,(A2:A21=H3)*(B2:B21=I3)*(C2:C21=J3))