Create dependent drop down lists in Excel
“Limit the choices in an Excel drop down list, by using named ranges and the INDIRECT function, to create dependent data validation lists. For example, select Fruit in column A, and only Fruit items appear in the drop down list in column B.”
Another Excel solution in search of a problem. I must be able to try this out on something…
Miscellaneous Details 