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

By using a drop-down list, you can make data entry more efficient and error-free. You can also create a dependent drop-down list in Google Sheets so that the first list choice determines the options for the second. Let’s watch at how to create a dependent drop-down list in Google Sheets.


Chapters:
0:00 Intro
0:23 Name the ranges
1:08 Create the first drop-down list
2:00 Insert the function
2:28 Create the dependent drop-down list
3:15 End screen


What you’ll learn:
1. Name the Ranges
a. How to name the ranges that contain the list items
b. How to create the first drop-down list
2. Create the First Drop-Down List
a. Data validation
3. Insert the Function
a. How to insert the INDIRECT function
4. Create the Dependent Drop-Down List













Song: LiQWYD – Let Go
Music provided by Vlog No Copyright Music.
Creative Commons – Attribution 3.0 Unported
Video Link: https://youtu.be/OOaedtlOFN8

#computereverywhere #howtocreate #dependent #dropdownlist #googlesheets