Drop down list options

Hello everyone!!

As you can see I have 4 drop down menus with the drop down menu 'Armour', 'Weapon
option 1' and 'Weapon option 2' beign dependant on what option I chose out of the drop
down box marked 'Leader', as well as each option associated numeric value.

I have labeld each range on Sheet 2 apart from the range for the terminator armour
weapon options.

The weapon options are the same for power armour and artificer armour, but differant for
terminator armour. What I would like to have is after I select the terminator armour option
a differant drop down box appears in Weapon option 1 and Weapon option 2 that is
dependant on the 'Leader' option and 'Armour option.

I have attached a worksheet to hoppfully make things clerear on what I would like to achieve.

I hope I have not confused you to much!!

Kind regards

Thanks for the link!! I looked into it and tried out the example there, but to tell you the truth it just confused the hell out of me!! Is there any other way I can get what I need?

Kind regards

check out this site I think you will find what you need and very easy to understand

https://sites.google.com/a/madrocket...ssistant/files

Thanks for the link just had a look at it and I think I need to put a counter argument in the weapon option1 and weapon option 2 data validation box. Have no idea how to do this but will give it a go and get back to you later. Thanks again!!

Kind regards.

Argh have tried and tried and tried again just cant get it to work. Anyone know of a formula I could use?

Kind regards

Hi Jeff,

Using your example. Each cell on the right is dependant on the cell to the left.

Lets say for each selection in the 'Classes' list gave us the normal options as well as a 'Universal' option. But if you select the universal option in the 'Types' list then instead of the 'Animals' beign dependant on 'Types' it would have to be dependant on 'Classes' and 'Types' when the universal option was chosen as you would have several different resulsts in the 'Animals' list for 'Universal' depending on the 'Classes' chosen.

I have included your example below updated with the option 'Universal'

Yeah that looks like the one thanks so much for your help. Will play around with it now and let you now how I get on. Thanks again!!!