If/Then with text in a column

[mlagorio]

I have a very simple column of text which is a result of some if functions. Now I want to choose one word depending on the condition. My column might look like this depending on the condition of the input.


red
green
green
yellow
yellow

How can I have a formula to return:
IF "red" anywhere in the column return red
IF no "red" then check for "yellow" and return yellow.
IF only green then green

Super simple I know, but I'm stuck.

Thanks

Michele

 

[AD_Taylor]

Welcome to the forum! Try,

=IF( ISERROR(MATCH("red", A:A, 0)), IF( ISERROR(MATCH("yellow", A:A, 0)), IF( ISERROR(MATCH("green", A:A, 0)), "", "green"), "yellow"), "red")

With the values being in Column A for this example.

 

[mlagorio]

I have a very simple column of text which is a result of some if functions. Now I want to choose one word depending on the condition. My column might look like this depending on the condition of the input.


red
green
green
yellow
yellow

How can I have a formula to return:
IF "red" anywhere in the column return red
IF no "red" then check for "yellow" and return yellow.
IF only green then green

Super simple I know, but I'm stuck.

Thanks

Michele

Oh My Gatos! You are the BEST!
Spent 2 daze (LOL) on this and now it's solved
Thank you Thank you Thank you