How to remove choices once selected

[Austin_Samagam]

so I’ve got 2 Tables.

Table 1 is my Main sheet, Table 2 has data that i’m pulling into Table 1 via Dereference.

Once I make my selection in Table 1, is it possible to make that option disappear to avoid selecting it twice and make it easier to choose from as only the not-used options are available?

hope this make sense.
thanks!!!

[Jeremy_F]

Yes, It is possible

In the dropdown column, use valid formula - Select(Table2[Column with options], True) - Select(Table1[Column with dropdown], True)