s10002096

回復 10# ANGELA


   
不好意思，我把資料上傳了，我現在遇到的問題是*幾無法顯示出來，自己有改了一下公式變成=VLOOKUP(MID(N3,1,3),勿動!$A$1:$B$21,2,)&MID(N3,4,2)&IF(LEN(N3)-LEN(SUBSTITUTE(N3,"、",""))>=1,"、"&VLOOKUP(MID(N3,7,3),勿動!$A$1:$B$21,2,),"")&MID(N3,4,2)&IF(LEN(N3)-LEN(SUBSTITUTE(N3,"、",""))>=2,"、"&VLOOKUP(MID(N3,13,3),勿動!$A$1:$B$21,2,),"")&MID(N3,4,2)&IF(LEN(N3)-LEN(SUBSTITUTE(N3,"、",""))>=3,"、"&VLOOKUP(MID(N3,19,3),勿動!$A$1:$B$21,2,),"")&MID(N3,4,2)&IF(LEN(N3)-LEN(SUBSTITUTE(N3,"、",""))>=4,"、"&VLOOKUP(MID(N3,25,3),勿動!$A$1:$B$21,2,),"")
可是這樣變成如果只key一個就會重覆*幾，這樣我的公式如何變更

ANGELA

=VLOOKUP(MID(N3,1,3),勿動!$A$1:$B$21,2,)&MID(N3,4,2)&IF(LEN(N3)-LEN(SUBSTITUTE(N3,"、",""))>=1,"、"&VLOOKUP(MID(N3,7,3),勿動!$A$1:$B$21,2,)&MID(N3,10,2),"")&IF(LEN(N3)-LEN(SUBSTITUTE(N3,"、",""))>=2,"、"&VLOOKUP(MID(N3,13,3),勿動!$A$1:$B$21,2,)&MID(N3,16,2),"")&...............