Microsoft Office Tutorials and References
In Depth Information
Data Validation
Creating a dependent list
Figure 19-31 shows a simple example of a dependent list created by using data validation. Cell E2
contains data validation that displays a list from the range A1:C1 (Vegetables, Fruits, and Meats).
When the user chooses an item from the list, the choice in a second list (in cell F2) displays the
appropriate items.
This worksheet uses three named ranges:
h Vegetables : A2:A5
h Fruits : B2:B9
h Meats : C2:C5
Cell F2 contains data validation that uses this formula:
=INDIRECT($E$2)
Therefore, the list displayed in the drop-down list depends on the value displayed in cell E2.
Figure 19-31: The items displayed in the list in cell F2 depend on the list item selected in cell E2.
 
Search JabSto ::




Custom Search