I have created following query
我创建了以下查询
=MATCH(TRUE, ISNUMBER(SEARCH({"a","b","c","d"}, "b")), 0)
=MA
阅读背景：
Excel匹配函数不能正确处理数组参数
来源：互联网
分享到：
