Question

excel提取满足多个条件的数值？

excel提取满足多个条件的数值，如下图

Answer 1

=INDEX($C$2:$F$13,MIN(IF(LOOKUP(ROW($A$2:$A$13),IF($A$2:$A$13<>"",ROW($A$2:$A$13),""),$A$2:$A$13)&$B$2:$B$13=$A19&$B19,ROW($1:$12),"")),MATCH(C$18,$C$1:$F$1,))

CTRL+SHIFT+回车，然后右拉

Answer 2

=SUMPRODUCT(($B$2:$B$13=$A19)*($C$2:$C$13=$B19)*OFFSET($D$2:$D$13,0,MATCH(C$18,$D$1:$G$1)-1))