Drop down list Determined By Cell Value

[BDNH]

Me again

Can I make a drop down list that is based on a cell value?
On Sheet 1 I use a Drop down list in cell U5 to choose the nominal Outside Diameter (OD) of the pipe I want to work with.

On Sheet 2 In Cell A8 I have a VLOOKUP formula that returns the physical OD of the pipe. I want a drop down list that would let me choose the possible wall thickness'(WT) for this size of pipe I would like this list on sheet 2 cell D8 I need it to change depending on what the VLOOKUP returns in cell A8

example: I choose a nominal OD of 6" on sheet 1 U5 - The VLOOKUP on sheet 2 A8 retunes 6.625" I have a named range on Sheet 3 with the possible wall thickness named "SixInWT". How do I get the drop down list to use this named range instead of another? the possible nominal OD sizes range from 2.5" to 24" each with their respective Wall thickness choices

In short - I need the drop down list to use a different named range depending on the value of a certain cell

Clear as mud?

thanks in advance

 

[SkipVought]

Hi,

Check out this solution

http://www.contextures.com/xlDataVal02.html

It specifically refers to Data/Validation but could be applied to Combo/List box dynamic list assign.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[BDNH]

Thanks Skip

Looks like just what I'm looking for