=IF(ISNUMBER(SEARCH("XX-XXXXX-79",E2)), "True", "False")
I have also tried to use
=IF(ISNUMBER(FIND("XX-XXXXX-79",E2)), "True", "False")
I am trying to use the following to search cell.
I am trying to find the last 2 values in the cell. If XX-XXXXX-79 then I want the value to return True. If XX-XXXXX-XX returns any value other than XX-XXXXX-79 then return False.
I can only get it to return a False value.
ANyhelp would be appreciated
Aucun commentaire:
Enregistrer un commentaire