You can add a Data Validation list based on the value of another cell.
For this example, it uses the VBA code – Windows Username – depending on who is accessing the workbook will depend on the list of values they will be shown in the Data Validation list.
Using a simple lookup if the user is part of the “BSA” team this will show the BSA list, if not in the list, to show the “Training” list. These lists are created using “Named Ranges”.
Really simple to use and very effective!