Output a value depending on which of the multiple criteria are met

[amai93]

Hi All,



I want to have a formula that would do the following in Column 2:

1. If column 1 contains the word "stock", output "stock" in column 2
2. If column 1 contains the word "premium", output "premium" in column 2
3. If column 1 contains the word "floor", output "floor" in column 2

I tried using a combination of IFS an SEARCH functions but the IFS function would break if one of the SEARCH function provides an error.

Is there a way to do this in one column?

Thanks!