I want to replace multiple items within a single field but CASE does not work and I cannot get REPLACE to replace more than one item a time. Any help on how do do this. example for the lookup 1 = green 2 = red 3 = amber/green 4 = amber/red
... View more