excel提取满足多个条件的数值?
发布网友
发布时间：2022-05-12 02:05
共2个回答
热心网友
时间：2022-05-31 13:48
=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+回车，然后右拉
热心网友
时间：2022-05-31 13:48
=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))
