I have many items which need to be classified according to either their status, range or description, depending on what each one is. The status, range and description of each of my products appear in different columns.
If the product has a "Bargain" status then it should be classified as...