Why only part of it? Maybe I misunderstood the dilemma.

Do you mean that column B needs to have a "C" in it, and column C needs to contain all 3 of X, Y and Z?