Dependant drop down help.

rstebbing1709

New Member
Joined
Jul 10, 2020
Messages
1
Office Version
  1. 2013
Platform
  1. Windows
Hi all,

I am hoping someone may be able to help me out with what I am trying to achieve. I am relatively new to using Excel and will be honest not too good with it, however through YouTube videos I have managed to set up some dependant drop downs. What I am stuck on is the following:

I have my first drop down that displays a list of phone brands, I then have a second dependant drop down that displays the models associated with that brand. What I am trying to get is a third drop down that will list specific tariffs based on what is selected in the second drop down. I have worked out a way to achieve what I want using the IF(or formula but this comes with the obvious downside of having to change the entire formula every time a device or tariff is added or removed.

My end goal is: drop down box 1 - Samsung is selected > Drop Down box 2 - then gives me the Samsung devices > Drop down box 3 - then gives me a tariff range based on the device selected in drop down box two. I will need a way to do this for multiple options as for example the Samsung S20 may have 1,5,8 and 20GB and the Samsung A10 may have 2,7,11 and 15GB available.

I really hope that makes sense and I've not gone on too much.

Many thanks for any help 🙂
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

AntMac

Board Regular
Joined
Dec 1, 2009
Messages
131
Hello, from what you have said I'm assuming drop down box 2 work with the selection in drop down box 1? If that's the case, what is happening when you setup box 3 the same way but in reference to box 2? I'm trying to get more feedback on where it's going wrong.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,188
Messages
5,570,755
Members
412,340
Latest member
nikitesh95
Top