Excel分级计算套餐?答:你要的公式:=IFERROR(IF(COUNT($A2:$B2)=2,MIN(LOOKUP($A2,$E$3:$E$6,$G$3:$G$6),LOOKUP($B2,$F$3:$F$6,$G$3:$G$6)),IF($A2>0,LOOKUP($A2,$E$7:$E$11,$G$7:$G$11),LOOKUP($B2,$F$12:$F$13,$G$12:$G$13))),0)...
Excel中如何查找出某一列中的数据包含某一列里面的特定字符数据,并返 ...答:在D2中输入或复制粘贴下列公式 =IFERROR(LOOKUP(1,0/FIND(C$2:C$5,B2),C$2:C$5),"无关键词")或 =TEXTJOIN(",",,IF(ISNUMBER(FIND(C$2:C$5,B2)),C$2:C$5,""))下拉填充