data valadation

[bamaisgreat]

ok, what I am trying to do is have three independent list i need the list 2 to be determined by the 1st one. Thanks for the help

One more thing, I need a video or a link explaining how to have a data valadation list inside another one.( one drop down and then after choosing another drop down appears.

 

[Andrew Poulsom]

For data validation with dependent lists see:

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

 

[bamaisgreat]

a problem i am having is that not all of the items in my range in the first data valadation list have a range that need to be in the second data validation list. I get a error when I try to do this.(The sourse currently evaluates to an error. Do you want to continue?)

 

[Andrew Poulsom]

Did you continue? Is it causing a problem?

 

[bamaisgreat]

yes, I continue. The list has nothing in it.

 

[Andrew Poulsom]

Please explain your setup in detail.

 

[bamaisgreat]

https://skydrive.live.com/redir.asp...BC39913B0562FDC9!105&authkey=!AL0VSXuVADLsEGQ

This is the link to a example of what Im trying to do..... Thanks

 

[Andrew Poulsom]

Make a list of your measurements like this:

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64 x:str><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17 width=64>1 1/2"</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>2"</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>3"</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>4"</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 12.75pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=17>5"</TD></TR></TBODY></TABLE>

name it List and assign it to Data Validation in B1. Define the following names for your second choices:

_1_1_2
_2
_3
_4
_5

and for your dependent validation use the formula:

=INDIRECT("_"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B1," ","_"),"/","_"),"""",""))