Dependent dropdowns

I am trying to wrap my brain around dependant dropdowns and have hit a brick wall.

Using the Contextures web site [URL="http://www.contextures.com/xlDataVal02.html#TwoWord"] I can get part of the problem to work but when I try to add a third dropdown i get lost.

Attached is a sample of the workbook.


Thanks, Jim O

Hi,

you cannot get rid of the underscore "_" in the range name, because range names don't allow spaces.

In order for the third drop down to work, you must create ranges that are called whatever the selection in the second drop down is. For example, if C4 has "ACC" then you must have a range on the conference sheet called "ACC" which would be D2:D13. Then the validation formula for C5 is

=indirect(c4)

You ned to understand that Indirect takes the value in the cell (the text "ACC") and creates a reference from it (the range called "ACC"). If such a reference is not defined, the validation will not work.

does that help?

you could use a dot as in "my.range"

Jogier505,

See the attached workbook "Dependant dropdown problems - Jogier505 - SDG11.xls".

All three dependant lists are now working.

See the notes in red.