I have a column that was a name of a product, which is customer-facing, and I have another column that I use for myself. I would like to create a formula where

if (Column B contains the word Blue)

output BLUE to column B

If (Column B contains the word Whale)

output WHALE in column B

If neither is true output ERROR

I’ve tried so many options, nested ifs, and substitutes … I only have 5 products, so I also tried using a switch statement … but it’s not working … does it only work with integers?