通配符號 匹配對應列 (14424)

D2 (VLOOKUP研討用)=IFERROR(VLOOKUP(SUBSTITUTE(A2,LOOKUP(1,0/FIND(G$2:G$7,A2)/(G$2:G$7>0),G$2:G$7),LOOKUP(1,0/FIND(G$2:G$7,A2)/($G$2:$G$7>0),H$2:H$7)),B$2:B$7,1,),A2)

E2=LOOKUP(1,0/(B$2:B$7=A2),B$2:B$7)