Dependent drop-down lists allow you to create dynamic forms where the options in one cell change based on the value selected in another. This is achieved using Named Ranges and the INDIRECT function.
Hazlo con IAPrepare your data and create named ranges
Organize your data into columns, select each category list, and assign a name to each range using the Name Box in the top-left corner.
Create the first drop-down list
Select the target cell, go to the Data tab, click Data Validation, choose List, and enter your category names in the Source box.
Create the dependent drop-down list
Select the second cell, go to Data Validation, choose List, and enter '=INDIRECT(A1)' (assuming A1 is your first list) in the Source box.
=INDIRECT(cell_reference)Check if the name of the range exactly matches the text selected in the first drop-down list.