Is there an easier way to do what I'm trying to achieve?
I am currently using an isnumber search formula to search for strings. Problem is, I ran out of room in the formula box.
Attached is an example
IsNumber_Search_Multiple_Criteria.xlsx
Example Code
=IF(OR(ISNUMBER(SEARCH("formula",A2)),ISNUMBER(SEARCH("function",A2))),"Formulas",IF(OR(ISNUMBER(SEARCH("help",A2)),ISNUMBER(SEARCH("training",A2)),ISNUMBER(SEARCH("tutorial",A2))),"Training","False"))
I'd like to be able to use some kind of easier formula to work with. One where I can type it in an array-type formula like:
=if(isnumber(search({"formula","function"},"Formulas",If...
Is there any way to do a multiple criteria isnumber search array?
Bookmarks