=IF((--IFERROR(FIND(21,D2,2),100))<9,"8JWCP21A99",IF((--IFERROR(FIND(21,D2,2),100))=9,VLOOKUP(B2,{"统一管理","8JWCP13G86";"合资","8JWCP13G99";"独立核算站","8JWCP13G99";"IC卡网点","8JWCP13A97";"合资车队","8JWCP19003";"管理人员","8JWCP19003";"借调","8JWCP19003"},2,0),""))
公式有点长。没办法
|