I've been trying to get Column B to return an "X" whether the cells in the adjacent Columns C:N have"X" or "Y", and a zero if they are all blank. I'm close, but the formula is returning a "Y" value in Column B in cases where only "Y" is present. Anyone have any suggestions?

Current formula: =IFERROR(LOOKUP("X",C3:N3),IFERROR(LOOKUP("Y",C3:N3),0))