Help with dependent drop down list

[aRabidLunatic]

Good afternoon guys, I've spend a few hours following examples online but can't figure this one out.

Here is what I'm tryin to do. In the data tab I have 2 columns. as you can see option1 has several items that correspond to it in option2. In the dropdown list I want to select Item1 from the first dropdown and then the second dropdown only show the items from Option2 that correspond to item1

[alansidman]

Look at my changes to your spreadsheet and look at this tutorial

https://www.ablebits.com/office-addi...n-lists-excel/

[mehmetcik]

If there are only two drop downs that you are interested in then that can be done using a formula.

If you have lots of them then you will need a macro.

Please Login or Register  to view this content.

[aRabidLunatic]

Thank you both. I think the Macro is my best option. I'll give it ago

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.