函数优化

xmtt

=IF(ISERROR(FIND("AAA区",F1)),"AAA",IF(ISERROR(FIND("BBB区",F1)),"BBB",IF(ISERROR(FIND("CCC区",F1)),"CCC",IF(ISERROR(FIND("DDD区",F1)),"DDD",IF(ISERROR(FIND("EEE区",F1)),"EEE",IF(ISERROR(FIND("GGG区",F1)),"GGG",”无“))))))
请高手帮忙修正，要实现自动取关键字，谢谢！


补充内容 (2024-9-3 09:19):
请大师帮改进：=IFERROR(LOOKUP(,-FIND({"AAA区","BBB区","CCC区","DDD区","EEE区","GGG区"},E1),{"AAA","BBB","CCC","DDD","EEE","GGG"}),"无")，若同时出现多个关键字时，如何优先匹配提取字段的第1个，而不是...

jivy1212

1. =IFERROR(LOOKUP(,-FIND({"AAA区","BBB区","CCC区","DDD区","EEE区","GGG区"},E1),{"AAA","BBB","CCC","DDD","EEE","GGG"}),"无")

复制代码

leepoison

=IFERROR(CHOOSE(MATCH(TRUE, ISNUMBER(SEARCH({"AAA区","BBB区","CCC区","DDD区","EEE区","GGG区"},F1)),0), "AAA", "BBB", "CCC", "DDD", "EEE", "GGG"), "无")

leepoison

=IFERROR(CHOOSE(MATCH(TRUE, ISNUMBER(SEARCH({"AAA区","BBB区","CCC区","DDD区","EEE区","GGG区"},F1)),0), "AAA", "BBB", "CCC", "DDD", "EEE", "GGG"), "无")

xmtt

jivy1212 发表于 2024-2-20 12:47

请老师帮改进，若同时出现多个关键字时，如何优先匹配提取字段的第1个，而不是匹配到最后一个。