vendredi 9 mars 2018

Using IF statements to Search a Cell and Return a Value

=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