I have a table with cells that are currently using the following formula: =IFERROR(IF(MATCH($B4,Roster!$J$9:$J$63,0),"Yes"), "")

I have conditional formatting in place depending on if the result is yes or no.

What I want is the ability to apply data validation where I can override the formula and select something like "Down" or "In Shop" from the list, but then if not selected the formula is there... So basically the formula is the default that could be overridden but always there it not...

Is this possible?

Thank you!