Excel 2016：在单元格中搜索多个术语(Excel 2016: Searching for multiple terms in a cell)

 我正在尝试在Excel 2016中使用OR条件搜索单元格中的多个字符串。 
 
 例如，我有一个字符串abcd1234 ，我想找到ab OR 12 。 
 
 我正在使用德语版本，其中函数SEARCH被称为SUCHEN ，它应该以相同的方式运行。 
 
 我发现这个答案表明了这个解决方案： 
 
 SEARCH({"Gingrich","Obama","Romney"},C1) 。 
 
 我还发现这个网站建议使用相同的语法： 
 
 SEARCH({"red","blue","green"},B5) 
 
 与本网站相同： 
 
 SEARCH({"mt","msa","county","unemployment","|nsa|"},[@Tags]) 
 
 因此，他们基本上会说出一个由大括号括起来的逗号分隔的搜索词列表，你很好。 
 
 但是将它们放入Excel 2016只会导致通常无意义的Excel错误消息，该消息表明公式存在错误，并且它总是突出显示花括号中的整个部分。 
 
 以第一个例子为例，我可以让Excel不抛出错误信息的唯一方法是更改​​语法，如下所示： 
 
 =SEARCH({"Gingrich";"Obama";"Romney"};C1) 
 
 但是用分号分隔搜索项并不能正确应用OR条件，因此这不是解决方案。 
 
 我从这个答案中知道我可以进行单独搜索并将它们与条件串在一起，但是我想避免这种情况，我也想知道为什么多个源确认的语法不起作用为我工作。 
 
 编辑： 
 
 好的，我开始明白这一点，感谢Solar Mike： 
 
 代码=IF(COUNT(SEARCH({"Romney","Obama","Gingrich"},A1)),1,"")确实完美无缺。 
 
 此外=COUNT(SEARCH({"Romney","Obama","Gingrich"},A1))工作。 
 
 但是=SEARCH({"Romney","Obama","Gingrich"},A1)没有。 
 
 此外=ISNUMBER(SEARCH({"Gingrich","Obama","Romney"},A1))不起作用。 
 
 我很想知道原因。 

I'm trying to do a search for multiple strings in a cell with an OR-condition in Excel 2016.
 
E.g. I have a string abcd1234 and I want to find ab OR 12.
 
I'm using the german version where the function SEARCH is called SUCHEN and it should behave the same way.
 
I found this answer which suggests this solution: 
 
SEARCH({"Gingrich","Obama","Romney"},C1).
 
I also found this website which suggests the same syntax: 
 
SEARCH({"red","blue","green"},B5)
 
Same with this website:
 
SEARCH({"mt","msa","county","unemployment","|nsa|"},[@Tags])
 
So they basically say make a list of search terms separated by commas enclosed by curly braces and you're good.
 
But putting these into Excel 2016 just results in the usual meaningless Excel error message which says there was an error with the formula and it's always highlighting the whole part in curly braces.
 
Taking the first example the only way I could get Excel to not throw its error message was to change the syntax like this: 
 
=SEARCH({"Gingrich";"Obama";"Romney"};C1)
 
But separating the search terms with semicolons doesn't apply the OR-condition correctly, so this is not the solution.
 
I'm aware from this answer that I could make separate searches and string them together with a condition, but I would like to avoid that, and I also want to know why the syntax that is supposed to work as confirmed by multiple sources is not working for me.
 
EDIT:
 
Okay, I'm starting to understand this, thanks to Solar Mike:
 
The code =IF(COUNT(SEARCH({"Romney","Obama","Gingrich"},A1)),1,"") works indeed perfectly fine.
 
Also =COUNT(SEARCH({"Romney","Obama","Gingrich"},A1)) works.
 
But =SEARCH({"Romney","Obama","Gingrich"},A1) does not.
 
Also =ISNUMBER(SEARCH({"Gingrich","Obama","Romney"},A1)) does not work.
 
I'd love to know the reason why.

原文：https://stackoverflow.com/questions/51472960