Is there a shorter formula to search for 1 or more specific keyword/s within a range of cells? For example, I'm looking for the words "Hardware" and "Software" from cells D5 to H5, if one of these cells contains either "Hardware" or "Software or both, it will input "5" in cell C5.
=IF(NOT(ISERROR(SEARCH("Hardware",C3))),6,IF(NOT(ISERROR(SEARCH("Software",C3)) ),6,"0"))
Although this code I have is working, but is it possible if I merge "Hardware" and "Software" and browse cells D5 to H5 if they contain either words? Thanks
Aucun commentaire:
Enregistrer un commentaire