数据有校车跟外租车2种数据的车牌信息,当我输入123是校车,输入456是外租车,什么公式可以解决,求
1、INDEX和MATCH,
=IFERROR(INDEX(B1:B2,MATCH(C1,A1:A2,0)),"")
2、IF
=IF(D1=123,"校车",IF(D1=456,"外租车",""))
3、VLOOKUP
=IFERROR(VLOOKUP($E$1,$A:$B,2,),"")
热门标签:
1、INDEX和MATCH,
=IFERROR(INDEX(B1:B2,MATCH(C1,A1:A2,0)),"")
2、IF
=IF(D1=123,"校车",IF(D1=456,"外租车",""))
3、VLOOKUP
=IFERROR(VLOOKUP($E$1,$A:$B,2,),"")