Alright, let me try to explain everything from the beginning.

The sheet named "Actual Appraisal Form" is where I want the drop down to be placed (Row 25 to 36 to be precise).

Cell A25, A28, A31 & A34 are the categories under which each employee will be evaluated. Lets call them as "Topics" from now on. They are highlighted in Grey.


Under each Topic , there are sub points, For example, in the sheet "Comments", Column D shows the Topics and Column E shows the sub points.

1) Now what is required is that I need a drop down menu under Cell A25 (Social Competencies) which shows the sub points in Column E of the "Comments" sheet.

2) 2nd drop down will be under cell C26. Which will contain 3 common items (i.e., 'Does Not Meet Expectations', 'Meets Expectations', 'Exceeds Expectations')

3) Based on the previous 2 cells' (A26 & C26) selection, 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 C "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". In the Comments sheet, you can see subtopics highlighted in peach color, and right next to it is the Topic mentioned just for your reference.

4) So, If a person selects "Sharing Information" subtopic 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". In the Advise sheet, you can see subtopics highlighted in peach color, and right next to it is the Topic mentioned just for your reference.

Please do let me know if my explanation was clear this time.