=LOOKUP(1,0/ISNUMBER(FIND(B$1:B$10,A1)),B$1:B$10)

我要回帖

 

随机推荐