Conditional Data Validation - Lists

wmurphy8989

New Member
Joined
Feb 19, 2015
Messages
9
Hello - I am looking for a way for my drop-down list to only display certain options based on a drop-down of another area. Essentially, I am looking at a Function vs. Subfunction. I want my data to be tied firstly to the function drop-down. Let's take for example:

Function (and sub-functions under each):
  • Research
    • Cardio
    • Bone
    • Oncology
  • Development
    • CBSS
    • Biostats
  • Operations
    • Drug supply
    • Compliance
    • Outsourcing
    • CAR

If I were to select Research in my first drop-down, I would want all the data below to generate ALL of research. In my second drop-down, I only want Cardio, Bone, and Oncology to display. But if I were to change my Research drop-down to Development, I would want my second drop-down to only display CBSS and Biostats. Is this possible? Thank you!

Will
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,214,936
Messages
6,122,340
Members
449,079
Latest member
rocketslinger

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