Drop Down List with special requirements.

[asanchez516]

Good morning all,

I've tried to do a drop down list with special requirements. These requirements are:

• I choose a maker, this directs me to specific models done by the vendor.
• Then I choose a model and for those models, there are different sizes and specific features for each
• Then I came with my problem. (Choose an specific features implies allowing only other specific data that goes with this feature.)

For example

Maker: Tyco Sprinkler Nozzles
Model: D-3 Protector Spray
and special features are:
I need to choose from a drop down list the orifice size and with another drop down list requiring if NFPA or SI units, put the values of Diameter and K factor specific for each orifice size in a drop down list. So, what I want is to make a drop down list of each column and when I choose the orifice size, all other values that don't correspond with the matching orifices size shall be removed from the Drop Down List.
[TABLE="class: grid, width: 500, align: center"]
<TBODY>[TR]
[TD][/TD]
[TD]NFPA[/TD]
[TD]NFPA[/TD]
[TD]SI[/TD]
[TD]SI[/TD]
[/TR]
[TR]
[TD]Orifice Size[/TD]
[TD]Diameter[/TD]
[TD]K Factor[/TD]
[TD]Diameter[/TD]
[TD]K Factor[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]0.203"[/TD]
[TD]1.2[/TD]
[TD]5.16mm[/TD]
[TD]17.3[/TD]
[/TR]
[TR]
[TD]18[/TD]
[TD]0.25"[/TD]
[TD]1.8[/TD]
[TD]6.35mm[/TD]
[TD]25.9[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]0.328"[/TD]
[TD]3[/TD]
[TD]8.33mm[/TD]
[TD]43.2[/TD]
[/TR]
</TBODY>[/TABLE]

 

[Benders]

Not sure if this is what you want... Follow these steps to see if this helps. Sorry about the Format.

1. Create 2 Named Ranges. One for A2:B4 as O_Size and the other A2:A4 as Orifice
2. Create 3 more Named Ranges (C2 as Size1, C3 as Size2 and C4 as Size3)
3. Cell A7. Goto Data Validation and Choose List and put =Orifice
4. Cell B7. Goto Data Validation and Choose List and put formula =INDIRECT (VLOOKUP(A7,O_Size,2,0))

Now if you select 16 in A7 , Cell B7 should only show 0.203".

[TABLE="width: 297"]
<TBODY>[TR]
[TD][/TD]
[TD]A</SPAN>[/TD]
[TD]B</SPAN>[/TD]
[TD]C</SPAN>[/TD]
[/TR]
[TR]
[TD]1</SPAN>[/TD]
[TD]Orifice Size</SPAN>[/TD]
[TD]D_size</SPAN>[/TD]
[TD]Diameter</SPAN>[/TD]
[/TR]
[TR]
[TD]2</SPAN>[/TD]
[TD]16</SPAN>[/TD]
[TD]size1</SPAN>[/TD]
[TD]0.203"</SPAN>[/TD]
[/TR]
[TR]
[TD]3</SPAN>[/TD]
[TD]18</SPAN>[/TD]
[TD]size2</SPAN>[/TD]
[TD]0.25"</SPAN>[/TD]
[/TR]
[TR]
[TD]4</SPAN>[/TD]
[TD]24</SPAN>[/TD]
[TD]size3</SPAN>[/TD]
[TD]0.328"</SPAN>[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6</SPAN>[/TD]
[TD]Choose Orifice</SPAN>[/TD]
[TD]Diameter</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7</SPAN>[/TD]
[TD="align: right"]24</SPAN>[/TD]
[TD]0.328"</SPAN>[/TD]
[/TR]
</TBODY>[/TABLE]

 

[asanchez516]

Thanks Bender

This is exactly what I need it. Now I'll try it in a more complex way

Thanks

 

[Benders]

Glad I was able to help.