How to create a nested drop-down list in Excel If you want to obtain data from some existing drop-down menus or cells and display options accordingly in a different cell, here is what you can do.

How to create a nested drop-down list in Google Sheets It is almost the same as Excel, but the name of the option is different. You need to select the List from a range option from the Criteria ...