mercredi 13 février 2019

How to search for two specific keywords in a range of cells

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