I want to create two dropdown lists. The second list should be dependent on what is selected in the first one.

[raghav8]

Hi All,

I want to create two dropdown lists. The second list should be dependent on what is selected in the first one.

The problem is the first drop-down list has spaces between words. For example - Business Services and I cannot replace the sapce with underscore as this data has tp be uploaded to a database.

Thanks in advance.
Raghav

 

[Andrew Poulsom]

If you define a name Business_Services and A1 contains the primary validation you can use this formula for the secondary validation:

=INDIRECT(SUBSTITUTE(A1," ","_"))

Similar to:

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

 

[raghav8]

Hey Andrew,
Thanks. The lists are working as of now. I am sure there will be more questions once we start populating data.

Thanks again.
Raghav