符號 "~" 用VLOOKUP查詢有誤的處理 (12620)

F6有誤=VLOOKUP(E2,B:C,2,)

F2=VLOOKUP(SUBSTITUTE(E2,"~","*~"),B:C,2,)

另解=LOOKUP(1,0/(B2:B6=E2),C2:C6)