How To Create a Dependent Drop-Down List in Google Sheets

In this tutorial, you will learn how to create a dependent drop-down list in Google Sheets

How To Create a Dependent Drop-Down List in Google Sheets

Quick Navigation

A dependent drop-down list is a type of data validation that changes based on the selection of another drop-down list. This can be a great way to make your data more interactive.

For example, let’s say you have a list of countries in one drop-down list and a list of cities in another. You want the city drop-down list to change based on the country drop-down list selection.

This guide will show you how to create a dependent drop-down list in Google Sheets.

How To Set Up a Dynamic Drop-Down List in Google Sheets

Here’s how to set up a dynamic drop-down list in Google Sheets.

Step 1

First, set up the options for the first drop-down list in a single row. These options will also act as the header for each column.

Step 2

Next, input the choices you want to display in the second drop-down menu.

In this example, we’ve set up a list of cities for each continent option.

Step 3

We’ll now create a named range for each sub-group. Select the first group of options under the first header.

Step 4

Click on the Named ranges option under the Data menu.

Provide the header as the name of the range and click Done to proceed.

Step 5

Create named ranges for each sub-group.

Step 6

Next, select an empty cell to place the first drop-down menu.

Step 7

Click on the Data validation option under the Data menu.

Step 8

In the Data validation rules panel, select Dropdown (from a range) as the criteria option. Provide the range that includes the options you want for the first drop-down list.

Step 9

Next, we’ll populate a new range with the appropriate sub-group using the INDIRECT function. The INDIRECT function allows the user to return a named range.