SEARCH function question

[cvgreports]

I have the following formula to Search for the word "Green" and to return the value "Green" in an adjacent cell. How would I go about also looking for the word "Blue" as well and return that value if "Green" is not found.

=IF(ISERROR(SEARCH("*Green*",G4,1)),"","Green")

Thanks

 

[njimack]

=IF(ISNUMBER(SEARCH("Green",G4)),"Green",IF(ISNUMBER(SEARCH("Blue",G4)),"Blue",""))

 

[T. Valko]

I have the following formula to Search for the word "Green" and to return the value "Green" in an adjacent cell. How would I go about also looking for the word "Blue" as well and return that value if "Green" is not found.

=IF(ISERROR(SEARCH("*Green*",G4,1)),"","Green")

Thanks

Maybe this...

=IF(COUNTIF(G4,"*green*"),"Green",IF(COUNTIF(G4,"*blue*"),"Blue",""))

 

[cvgreports]

Thank you so much, both formulas work perfect!

 

[T. Valko]

Thank you so much, both formulas work perfect!

You're welcome. Thanks for the feedback!