excel条件判断,当条件对等,条件重新顺序判断答:D2输入 =IFERROR(IF(B2=C2,"相等",IF(D1="相等",IF(B2=C$2,"相等","不相等"),IF(B2=INDEX(C:C,ROW(A3)-LOOKUP(1,0/(D$1:D1="相等"),ROW($1:1))),"相等","不相等"))),"不相等")公式下拉
【Excel】多条件判断成立后再取值答:if(iserror(vlookup(da1,f:f,1,false)),"",vlookup(da1,f:g,2,false) & vlookup(da1,f:l,7,false))