Hello, please would you be able to assist with what is incorrect in this forumla?
=IF(ISNUMBER(SEARCH("meeting",K98573,"Meeting",IF((ISNUMBER(SEARCH("management",K98573,"Management",IF((ISNUMBER(SEARCH("admin",K98573,"ADMIN",IF((ISNUMBER(SEARCH("development",K98573,"Development",IF((ISNUMBER(SEARCH("prep",K98573,"Prep",IF((ISNUMBER(SEARCH("office",K98573,"Office",""))))))
Solved by B. C. in 27 mins