Administration and Executive AssistantTier 255 minintermediate

Data Validation and Dependent Dropdowns

Constrain inputs and create linked dropdown menus.

What you will learn

• Create a dropdown list from a range
• Validate input with data types and constraints
• Use INDIRECT for dependent dropdowns
• Understand error alerts and how to customize them

Excel skills

Data Validation dialog, INDIRECT(), dependent lists · Input Control

The task

Twelve clients need a Region and a City. Region is a straightforward dropdown. City needs to only show the cities that actually belong to whichever Region was picked for that row - I do not want someone able to select Durban against a client marked as Western Cape.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free