请教：如何用Find函数查找多个字段，并返回原值

cfsonic · 发表于 2016-8-26 09:32

请教：如何用Find函数查找多个字段，并返回原值；
查找多个字段，想利用数组结合find函数实现但是失败~！

江苏永能朱兴华 · 发表于 2016-8-26 09:37

=IFERROR(LOOKUP(,-FIND({"GZS","BJS","WHS","SHS"},A2),{"GZS","BJS","WHS","SHS"}),"")

问山 · 发表于 2016-8-26 09:39

LOOKUP(,-FIND({"","GZS","BJS","WHS","SHS"},A2),{"","GZS","BJS","WHS","SHS"})

baksy · 发表于 2016-8-26 09:42

附件。。。

cfsonic · 发表于 2016-8-26 09:44

问山发表于 2016-8-26 09:39
LOOKUP(,-FIND({"","GZS","BJS","WHS","SHS"},A2),{"","GZS","BJS","WHS","SHS"})

非常感谢，实现了，拜一下~！

cfsonic · 发表于 2016-8-26 09:45

问山发表于 2016-8-26 09:39
LOOKUP(,-FIND({"","GZS","BJS","WHS","SHS"},A2),{"","GZS","BJS","WHS","SHS"})

感谢帮助，实现目标，我自己消化一下~！

jiny680p · 发表于 2016-8-26 10:06

=LOOKUP(1,0/FIND({"","BJS","WHS","SHS"},A2),{"","BJS","WHS","SHS"})

cfsonic · 发表于 2016-8-26 10:23

江苏永能朱兴华发表于 2016-8-26 09:37
=IFERROR(LOOKUP(,-FIND({"GZS","BJS","WHS","SHS"},A2),{"GZS","BJS","WHS","SHS"}),"")

不好意思，追加一个问题，如果想显示三个字后，紧跟着的4位数字，怎么实现呢，恳请大神的再次帮助？

准提部林 · 发表于 2016-8-26 10:36

cfsonic 发表于 2016-8-26 10:23
不好意思，追加一个问题，如果想显示三个字后，紧跟着的4位数字，怎么实现呢，恳请大神的再次帮助？

=MID(A2,-LOOKUP(,-FIND({"|","GZS","BJS","WHS","SHS"},A2&"|")),7)

cfsonic · 发表于 2016-8-26 10:44

准提部林发表于 2016-8-26 10:36
=MID(A2,-LOOKUP(,-FIND({"|","GZS","BJS","WHS","SHS"},A2&"|")),7)

请教，这个字符“|”，是怎么打出来的，作用是什么么？在下初学，有点无法理解~！恳请指教~！

		自动登录	找回密码
密码			免费注册

[求助] 请教：如何用Find函数查找多个字段，并返回原值