Variable Data Validation List Based on Cell Value

[David20]

Data Set:

Sheet1 (Table 'Alpha' on Sheet1!A1:B200)
-ColumnA: Employee_Name (sorted A-Z)
-ColumnB: Qualification_Code (01A, 01B, ..., 01Z) (Each employee has a single Code, but multiple employees have the same Code)

​

Sheet2 (Sheet2!A1:C100)
-ColumnA: Position_Title
-ColumnB: Position_Code (01A, 01B, ..., 01Z) (Each position has a single Code, but multiple positions can have the same Code)
-ColumnC: Qualified_Employee (where I want to put a drop-down list that only shows qualified employees based on the Position Code)​

Question:
How do I create a data validation list in Sheet2!ColumnC that will show a list of qualified employees based on the Position Code in Sheet2!ColumnB? Due to other functionalities, I have to leave Table 'Alpha' sorted as-is.

 

[MickG]

Try this example:-
https://app.box.com/s/tuk1slr3rvfnolm2wqmnabz1tk3k6te4

 

[David20]

Thank you for helping! Unfortunately, my work computer is pretty locked down and won't let me enable macros a downloaded .xlsm file. I'll test this at home and let you know if I have any questions.

 

[David20]

Your solution worked perfectly. Thanks for your help.

 

[MickG]

You're welcome