Creating a formula from another column

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?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.