I have a two-column table but I want all values in the first table to be either X or Y, and no other input should be allowed. How can I enforce this?
You can use a validation rule.
A Validation Rule on the column as follows will work.
="X" Or ="Y"