Independent Drop Down List

[Pontoz]

Dears

i need your assistance in the following :

I have a list of employees, their IDs, grades and job titles. For each job tile there are certain Competencies related to it and for each competency it has certain courses related to it. i created a sheet with ID drop down list and whenever you choose an ID, his or her related information will come ( Employee Name, Grade , Job ) i used the Vloopup Function. Now the challenge is that I need a drop down list in the Competency area which shows only competency related to the reflected job title and the same for the Course name which will be dependent on the Competency. Appreciate your support

ID	Employee Name	Grade	Job	Competency	Course related
173	Richie Blank	E	Assistant Manager - Talent Management	Drafting Skills	Legal Wiring
173	Richie Blank	E	Assistant Manager - Talent Management	Managing Resources	Recruitment Skills
173	Richie Blank	E	Assistant Manager - Talent Management	Teamwork and Team Leadership	Act as a team
113	Maybelle Bardin	E	Assistant Manager - Training	Empowering Others	How to Delegate
113	Maybelle Bardin	E	Assistant Manager - Training	Managing Change	Master Change
113	Maybelle Bardin	E	Assistant Manager - Training	Managing Performance	Performance Excel
118	Heriberto Tinsley	F	Manager - Talent Management	Attention to Communication	Communication Skills
118	Heriberto Tinsley	F	Manager - Talent Management	Oral Communication	Communication Skills
118	Heriberto Tinsley	F	Manager - Talent Management	Written Communication	Communication Skills
79	Tyesha Spiker	F	Manager - Training	Achievement Focus	Emotional Intelligence
79	Tyesha Spiker	F	Manager - Training	Analytical Thinking	Analytical Thinking & Creative Problem Solving
79	Tyesha Spiker	F	Manager - Training	Drafting Skills	Legal Wiring
135	Felisha Brent	F	Manager - Training	Diagnostic Information Gathering	Forcasting Techniques
135	Felisha Brent	F	Manager - Training	Influencing Others	Master your team
135	Felisha Brent	F	Manager - Training	Interpersonal Awareness	Interpersonal Skills
90	Elsa Scheurer	C	Officer - Competency Profiling	Drafting Skills	Legal Wiring
90	Elsa Scheurer	C	Officer - Competency Profiling	Flexible Thinking	Master Change
90	Elsa Scheurer	C	Officer - Competency Profiling	Influencing	Master your team
103	Lisbeth Dano	C	Officer - Competency Profiling	Developing Talent	Motivation & Leadership
103	Lisbeth Dano	C	Officer - Competency Profiling	Negotiating	Art of Persuasion
103	Lisbeth Dano	C	Officer - Competency Profiling	Teamwork and Team Leadership	Act as a team
99	Dorene Stockdale	C	Officer - Training	Negotiating	Art of Persuasion
99	Dorene Stockdale	C	Officer - Training	Organisational Knowledge	OD Design
99	Dorene Stockdale	C	Officer - Training	Strategic Thinking	Strategic Thinking & creative Problem Solving
145	Janise Westfall	C	Officer - Training	Achievement Focus	Emotional Intelligence
145	Janise Westfall	C	Officer - Training	Analytical Thinking	Analytical Thinking & Creative Problem Solving
145	Janise Westfall	C	Officer - Training	Forward Thinking	Master Change
84	Shane Primavera	D	Senior Officer - Training	Flexible Thinking	Master Change
84	Shane Primavera	D	Senior Officer - Training	Managing Resources	Recruitment Skills
84	Shane Primavera	D	Senior Officer - Training	Teamwork and Team Leadership	Act as a team
108	Sofia Silver	D	Senior Officer - Training	Developing Talent	Motivation & Leadership
108	Sofia Silver	D	Senior Officer - Training	Fostering Teamwork	Act as a team
108	Sofia Silver	D	Senior Officer - Training	Providing Motivational Support	Motivation & Leadership
88	Brianna Shoultz	H	VP - Head of Learning & Development	Analytical Thinking	Analytical Thinking & Creative Problem Solving
88	Brianna Shoultz	H	VP - Head of Learning & Development	Client Focus	Customer First
88	Brianna Shoultz	H	VP - Head of Learning & Development	Influencing	Master your team

<colgroup><col><col><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[ONEMINUTETUTORIAL]

Hi friend,

Check this...

https://trumpexcel.com/extract-data-from-drop-down-list/

100% this will help you.

Regards,

 

[ONEMINUTETUTORIAL]

Reference Link : https://trumpexcel.com/extract-data-from-drop-down-list/

 

[Pontoz]

Thanks a lot dear, i checked the file, however I'm not that expert in excel so i couldn't make it out. Aren't there any formula without the helper section cause i have more than 270,000 records in my database.

 

[ONEMINUTETUTORIAL]

ok. i will help. please upload the file and share the link.