mercredi 29 janvier 2020

Can I search a cell for specific text using IFS formula, and return text to current cell?

I was able to do this with a single IF formula, but cannot exactly figure out how to do it with IFS to search the same cell for different strings of text.

Here is the formula I am using for the single IF statement:

=IF(SEARCH("silver",B5),"silver","N/A")

It is searching cell B5 for the term "silver" and then if found it returns "silver". If not it returns N/A. I would like to be able to search cell B5 for different terms ("black","red","blue") using the IFS formula.

Here's a screenshot of the Excel rows

Thank you in advance!

Aucun commentaire:

Enregistrer un commentaire