根据全称匹配简称对应的费用类型

大自在天

哪位老师能帮忙写一下函数公式，结果如图B列所示

祝洪忠-

=LOOKUP(1,-FIND(D$2:D$5,A2),E$2:E$5)

ovxyz

B2=FILTER($E$2:$E$5,ISNUMBER(FIND($D$2:$D$5,A2)))

lachenfei

1. =VLOOKUP(REGEXP(A2,"酒店|通信|旅行|高速",3),D:E,2,0)

复制代码

mykitami

=UNIQUE(FILTER($B$2:$B$6,ISNUMBER(FIND(D2,$A$2:$A$6))))

袁勇

1. =LOOKUP(1,0/FIND(D$2:D$5,A2),E$2:E$5)

复制代码

你是那块小饼干

=LOOKUP(1,0/ISNUMBER(FIND($D$2:$D$5,A2)),$E$2:$E$5)

菜狗一只

1. =INDEX($E$2:$E$5,MAX(IF(ISNUMBER(FIND($D$2:$D$5,A2)),ROW($A$1:$D$4),"")))

复制代码