Creating a drop-down list that is dependent on another drop-down list.

Hello CrystalCannon,

Thanks for contacting us. Sure, I can help you with that. Here's how you can create a dependent drop-down list in Excel:

1. Create your first drop-down list using Data Validation. Select the cells where you want the drop-down list to appear, then go to the Data tab on the Ribbon and click on Data Validation.
2. In the Data Validation dialog box, choose List from the Allow dropdown menu, and then enter the source values for the drop-down list in the Source box. For example, if you're creating a list of countries, you might enter the names of all the countries in a column on the worksheet, and then enter the cell range for that column as the source for the drop-down list.
3. Click OK to close the Data Validation dialog box and create your first drop-down list.
4. Next, create a named range for each dependent list that you want to create. For example, if you want to create a list of cities based on the country selected in the first drop-down list, you might create a named range for each country that contains the cities for that country.
5. Go back to the cell where you created your first drop-down list, and select it.
6. Go back to the Data Validation dialog box, and this time, choose List from the Allow dropdown menu.
7. In the Source box, enter an INDIRECT function that refers to the named range for the dependent list based on the value selected in the first drop-down list. For example, if you named the ranges for each country based on the country name (e.g., "USA" for the named range of cities in the United States), you might use the following formula: =INDIRECT(A1)
8. Where A1 is the cell reference for the cell containing the first drop-down list. This formula will look up the named range that matches the selected country and use it as the source for the second drop-down list.
9. Click OK to close the Data Validation dialog box and create your dependent drop-down list.
10. Repeat steps 4-8 for any additional dependent drop-down lists that you want to create.

That's it. You should now have a set of dependent drop-down lists that update based on the value selected in the first drop-down list.

Regards, Akande