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!