Base a Data Validation dropdown on the Region values. Now, let’s use UNIQUE () to create a unique list of region values and then base a data validation dropdown on that list.

Take advantage of data annotations to decorate your models using attribute tags so that your application’s data definition can be managed in a single place.