lundi 6 avril 2020

IF ISNUMBER SEARCH - distinguish between similar text

Hoping someone smarter than myself can help:

Column F contains either of the words below, and I want to excel formula to return whether the data is "White" or "Pink"

  • Ban
  • Bandearg

=IF(ISNUMBER(SEARCH("Ban",F2)),"White",IF(ISNUMBER(SEARCH("Bandearg",F2)),"Pink")

The problem is that everything returns as "White" as it is finding "Ban" in both. Presume I am using the formula wrong.

Bán is the Irish for White and Bándearg is the Irish for Pink!

Aucun commentaire:

Enregistrer un commentaire