類似表列 取值 (11796)

C2=LOOKUP(1,0/(FIND(F$2:F$9,"@"&B2)>1),F$2:F$9)

D2{=LOOKUP(1,0/FIND(G$2:G$99,B2)/(MAX(LEN(G$2:G$99)*ISNUMBER(FIND(G$2:G$99,B2)))=LEN(G$2:G$99)),G$2:G$99)