Parse cell for 1 of 3 values, return corresponding string value

A cell will contain the words "GREEN", "YELLOW", or "RED". FWIW, the words will be surrounded by asterisks (e.g, "***GREEN***").

I am trying to craft an elegant formula that will parse the cell and return "Green", "Yellow", or "Red".

This is the formula I have so far, but it errors out if the original cell does not contain the first color ("GREEN"):

=IF(FIND("GREEN",'(BC-1)'!A107)>0,"Green",IF(FIND("YELLOW",'(BC-1)'!A107)>0,"Yellow",IF(FIND("RED",'(BC-1)'!A107)>0,"Red")))

I could add "iferror" I guess, but there may be a better way?

=IFERROR(IF(FIND("GREEN",'(BC-1)'!A107)>0,"Green"),IFERROR(IF(FIND("YELLOW",'(BC-1)'!A107)>0,"Yellow"),IFERROR(IF(FIND("R",'(BC-1)'!A107)>0,"Red"),"***ERROR***")))

Is there a more elegant solution? Thanks.

Re: Parse cell for 1 of 3 values, return corresponding string value

Quote from AliGW;790787

Bonus points for you, too, if you provide us with a sample workbook to work with.

Here ya go.

Re: Parse cell for 1 of 3 values, return corresponding string value

Yes. His solution worked. Thank you.