EXCEL中同时满足多个数值得出一个结果的公式答:C2: =IF(A3<0.8,"",HLOOKUP(B3,$I$1:$M$4,LOOKUP(ROUND(A3,2),{0.8,0.9,1},{4,3,2}),0))
Excel怎么从多列中查找条件值并返回条件值对应的某一个值?答:根据题意,设置公式如下:=VLOOKUP("*"&J2&"*",IF({1,0},$C$2:$C$4&$D$2:$D$4&$E$2:$E$4&$F$2:$F$4,$B$2:$B$4),2,)=VLOOKUP("*"&J2&"*",IF({1,0},$C$2:$C$4&$D$2:$D$4&$E$2:$E$4&$F$2:$F$4,$G$2:$G$4),2,)...
excel中同时满足多个条件后,返回一个单元格里的值?答:在D6中输入或复制粘贴下列公式 =INDEX(I$4:T$39,MATCH(B3,H$4:H$39,),MATCH(E3,I$3:T$3,))或 =VLOOKUP(B3,H:T,MATCH(E3,H3:T3,),)下拉填充
EXCEL多个条件判断最后返回一个值怎么搞?答:管家,老爷先来个笨办法 =if(or(A1={1,2,7,8,12,13,18,19,23,24,29,30,34,35,40,45,46}),"老爷我","")