Dynamic Display of List Values Based Upon Value Selected From Another List

kman

New Member
Joined
Dec 11, 2002
Messages
35
I have successfully created several drop down lists however I am trying to display different drop down values based upon a selection.

Ex. In cell A3 it displays a drop down list with the values Keyword, Certification, Skills

If a user selects Keyword from cell A3 I want them to be able to specify only values from the Keyword List which I've already created

If a user selects Certification from cell A3 I want them to be able to specify only values from the Certification List which I've already created

If a user selects Skills from cell A3 I want them to be able to specify only values from the Skills List which I've already created
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,109,456
Messages
5,528,868
Members
409,842
Latest member
mfernandezcean
Top