dependent Drop down lists

[jschill2628]

I have a drop down list that I have created (MBO). I have another drop down list that goes off of the first drop down list (MBO). But I cannot get the second drop down list to work…..

What I want my users to do is select an MBO from the list………….
St. Vincent Infirmary Medical Center, AR
Mercy Medical Center - Centerville, IA
MERCY MEDICAL CENTER - West Lakes, IA
Mercy Cancer Center Radiation Oncology, IA
Etc.

What I want the second drop down list to do is choose the following list (indented list) based off of the first (MBO) list……
St. Vincent Infirmary Medical Center, AR
St. Vincent Infirmary Medical Center
ST. VINCENT MEDICAL GROUP
St. Vincent Heart Clinic Arkansas
Mercy Medical Center - Centerville, IA
Mercy Medical Center - Centerville
MERCY MEDICAL CENTER - West Lakes, IA
MERCY MEDICAL CENTER - Des Moines
MERCY PROF PRACTICE ASSN
MERCY CLINICS INC.
PERINATAL CENTER OF IOWA
Mercy Cancer Center Radiation Oncology, IA
MERCY MEDICAL CENTER - West Lakes

I have looked at done all the steps regarding this using the following tutorial.

http://www.launchexcel.com/excel-dropdown-list-data-validation/#download

I think my problem comes from the periods and the commas, but I am not sure how to fix that in the formula I hve
=INDIRECT(SUBSTITUTE(B2," ","_"))


I Am using Excel 2003.

Thanks in advance!

 

[firefytr]

Hi there,

There is a lot of help on this topic on the web. Here are some links...

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

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

http://office.microsoft.com/en-us/e...on-to-create-dependent-lists-HA010285033.aspx

http://www.mrexcel.com/forum/excel-questions/32-cascading-combo-boxes.html

http://www.tushar-mehta.com/excel/newsgroups/cascading_dropdowns/index.html

If you're having issues with the named ranges, can you tell us what your named ranges are? The point in that formula for removing the spaces is the fact that the named ranges are titled with an underscore and not a space. So in order to do the dependency correctly it must substitute the space with an underscore.

For us to help you any further we would need to know what your named ranges are and where they're at.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP?
- Leonardo da Vinci