Hi,

In C15 try this: =IF($C$9="Blue Water";"Chill";IF($C$9="red water";"chill";""))