Search code examples
excel-formulavalueerror

How to search mutiple text

How do I search multiple text by using search formula?

I have tried multiple nested IF's but I am going over 64 levels but to overcome this problem, using multiple search would cut down some levels.

=search({"auburn", "hogansville", "lawrenceville"}, BR2)

Flowing formula gives value error why is that? I have googled and many people are using the exact same format above but for some reason its giving me a value error.

Solution

  • I guess you are checking for existence of any of those words, so you can use this:

    =SUMPRODUCT(--ISNUMBER(SEARCH({"auburn", "hogansville", "lawrenceville"}, BR2)))>0

    Which returns TRUE or FALSE.