類似值 找對應欄 (13196)

F2{=LOOKUP(1,0/(MAX(ISNUMBER(FIND(B$2:B$5,E2))*LEN(B$2:B$5))=LEN(B$2:B$5)),C$2:C$5)



留言