using an OR statement inside a =if(isnumber(search( formula

Hello All,

What I am trying to do is search for multiple terms within a single cell and return a value if it finds it, or return something else if it doesnt. This is what I have so far but it doesn't seem to be working.

=if(isnumber(search(or("llc","corp","ltd","limited","strata"),K2))),"Company","Individual")

I know that I can do it this way but it is far too cumbersome:

=if(or(isnumber(search("llc",k2)),isnumber(search("corp",k2)),isnumber(search("ltd",K2))),"Company","Individual")


My question is can I not include the OR statement after the search to search for multiple variables that way?

Thanks!

Here, try this:

Formula:

Please Login or Register  to view this content.

Or this maybe:

Formula:

Please Login or Register  to view this content.

Originally Posted by Tony Valko

You were very close.

Try it like this:

=IF(OR(ISNUMBER(SEARCH({"llc","corp","ltd","limited","strata"},K2))),"Company","Individual")

Went with this one... works like a charm thank you!

Quick question, what is the effect of having the { inside the formula? I thought that was used for array formula?

Originally Posted by zbor

Here, try this:

Formula:

Please Login or Register  to view this content.

Thank you, your take is rather itneresting as well. Why the "--" at the beginning of the isnumber?

Originally Posted by mysticmoron109

Thank you, your take is rather itneresting as well. Why the "--" at the beginning of the isnumber?

-- will convert TRUE/FALSE statements into 1/0 numbers that you can easily SUM

AH perfect, thank you guys so much for the tips! Will add to my excel arsenal

Another way...

=IF(SUM(COUNTIF(K2,"*"&{"llc","corp","ltd","limited","strata"}&"*")),"Company","Individual")