Independent Drop Down List

P

Pontoz

New Member
Joined
Sep 10, 2017
Messages
8
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

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

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Sort by date Sort by votes
Custom-Filter.gif


Reference Link : https://trumpexcel.com/extract-data-from-drop-down-list/
 
Upvote 0
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.
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,224,823
Messages
6,181,175
Members
453,021
Latest member
Justyna P

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top