Get instant live expert help on I need help with excel vba isnumber
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
=IF(ISNUMBER(FIND("BULK",AM41)),"Bulk",IF(ISNUMBER(FIND("DR",AM41)),"Drum",IF(ISNUMBER(FIND("TO",AM41)),"Tote",IF(ISNUMBER(FIND("BG",AM41)),"Bag",IF(ISNUMBER(FIND("SS",AM41)),"Supersack",IF(ISNUMBER(FIND("PL",AM41)),"Pail",IF(ISNUMBER(FIND("BX",AM41)),"Box""ERROR")))))))
Solved by B. W. in 13 mins
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
I have a problem regarding to Excel DATA VALIDATION using ISNUMBER and FIND Function
Solved by D. H. in 21 mins
I'm currently using this code: =IF(ISNUMBER(FIND("XS",Q2)),1,IF(ISNUMBER(FIND("S",Q2)),2,IF(ISNUMBER(FIND("M",Q2)),3,IF(ISNUMBER(FIND("L",Q2)),4,IF(ISNUMBER(FIND("XL",Q2)),5))))) All of them are working apart from the last option of XL makes 5. Can anyone help as to why this is the only one that isn't working?
Solved by B. H. in 12 mins
I need to combine a vlookup and isnumber i think
Solved by Z. B. in 27 mins