Notes in support of this thread:
https://excelfox.com/forum/showthrea...rop-Down-Lists
Following approximately these steps:
https://support.microsoft.com/en-us/...9-c5402dce407b
Worksheets info from OP:
Requirements:

1. Under "Social Competencies", the drop down list should contain all the headers from the sheet "Comments" (Color Code - Peach).

2. Under "Please Choose", the drop down list should contain "Does Not Meet Expectation", "Meets Expectation", "Exceeds Expectation" (Color Code - Grey).

3. So, If a person selects "Communicating Effectively" under Social Competencies column, and then selects "Meets Expectation" in the next column, then the drop down list on Column D "Please Choose" should display the list from B3:B8 from the sheet named "Comments".

Another example would be if a person selects "Resolving Conflict" under Social Competencies column, and then selects "Does Not Meet Expectation" in the next column, then the drop down list on Column D "Please Choose" should display the list from A13:A18 from the sheet named "Comments".

4. So, If a person selects "Sharing Information" under Social Competencies column, then the drop down list on Column E "Give Advise" should display the list from A28:A32 from the sheet named "Give Advise"
_____ Workbook: Appraisal - Drop Down.xls ( Using Excel 2007 32 bit )
Row\Col A B C D E
1 SOCIAL COMPETENCIES Please Choose Comments Give Advise
2
3
4
5
6
7
8
Worksheet: Appraisal



Continued in next post…._