EXCEL多条件显示数据答:B2 =IF(COUNTIF(Sheet1!$C$2:$C$5,$A2),IF(ISERROR(VLOOKUP(B$1,IF(Sheet1!$C$2:$C$5=$A2,Sheet1!$A$2:$B$5,""),2,)),"",VLOOKUP(B$1,IF(Sheet1!$C$2:$C$5=$A2,Sheet1!$A$2:$B$5,""),2,)),"") 复制公式,按组合键ctrl+shift+enter结束公式输入,右拉...
excel 中 if和vlookup可以结合一起用吗?这个比较急,麻烦大神帮忙看看...答:=IF(C2="卸车",VLOOKUP(A2,E:F,2,0),IF(C2="装车",VLOOKUP(B2,G:H,2,0),""))