Microsoft Office Tutorials and References
In Depth Information
As I describe previously, you can use data validation to create a drop-down list in a cell (see “Creating a Drop-
Down List”). This section explains how to use a drop-down list to control the entries that appear in a second
drop-down list. In other words, the second drop-down list is dependent upon the value selected in the first drop-
Figure 20-8 shows a simple example of a dependent list created by using data validation. Cell E2 contains data
validation that displays a three-item list from the range A1:C1 (Vegetables, Fruits, and Meats). When the user
chooses an item from the list, the second list (in cell F2) displays the appropriate items.
This worksheet uses three named ranges:
• Vegetables: A2:A15
• Fruits: B2:B9
• Meats: C2:C5
Cell F2 contains data validation that uses this formula:
Therefore, the drop-down list displayed in F2 depends on the value displayed in cell E2.
Figure 20-8: The items displayed in the list in cell F2 depend on the list item selected in cell E2.