用什么函数可以做到？多值查找拼接，并且顺序一样

美驴看电影 · 2021-12-8 02:53:46

飞彤 · 2021-12-12 02:06:10

=TEXTJOIN("、",1,XLOOKUP(TRIM(MID(SUBSTITUTE(A2,"、",REPT(" ",50)),ROW(1:9)*50-49,50)),D:D,E:E,""))

2021以上支持

仙人张 · 2021-12-12 13:27:19

=TEXTJOIN("、",1,XLOOKUP(TRIM(MID(SUBSTITUTE(A2,"、",REPT(" ",50)),ROW(1:9)*50-49,50)),D:D,E:E,""))

2021以上支持

收起你的好 · 2021-12-14 05:39:48

=TEXTJOIN(",",1,IF(COUNT(FIND(D2:D5,A2)),E2:E5,""))

浮生如夢 · 2021-12-14 08:08:15

=TEXTJOIN(",",1,IF(COUNT(FIND(D2:D5,A2)),E2:E5,""))

情韵枭枭 · 2021-12-14 20:02:07

貌似不行

芒果小喵 · 2021-12-16 19:51:12

貌似不行

我吃烤地瓜 · 2021-12-17 08:27:21

乾坤生命 · 2021-12-20 14:03:30

=TEXTJOIN(",",,IF(FIND(D1:D4,A1)>0,E1:E4))

襄王无梦 · 2021-12-23 22:35:12

=TEXTJOIN(",",,IF(FIND(D1:D4,A1)>0,E1:E4))

		自动登录	找回密码
密码			立即注册