Create intermediate Works with: Any AI

Dependent Dropdown in Google Sheets Without Scripts

Table output Has example

• 📈 Google Sheets

Create dependent dropdowns in Google Sheets with data validation and formulas, no script needed, including a layout tab and an error troubleshooter.

The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.

[VERIFY] is an editorial flag, not a blank to fill. Wherever the prompt shows [VERIFY], check that item against a reliable source before you use it.

Walk me through creating a dependent dropdown in Google Sheets with no Apps Script. Parent list: [PARENT_CATEGORY] ([PARENT_OPTIONS]). Child list: [CHILD_CATEGORY] ([CHILD_OPTIONS_BY_PARENT]). The form or tracker tab where the dropdowns go: [TARGET_TAB_AND_CELLS]. How often my options change: [CHANGE_FREQUENCY].

Design a helper tab layout first (show it as a table), then give numbered steps:

1. Build the lookup table with parent options as headers and child options below.

2. Create the parent dropdown using data validation from a range.

3. Create a helper cell that returns the child options for the chosen parent, with the formula (for example using INDEX and MATCH, or FILTER); show the formula with my real cell addresses.

4. Create the child dropdown from the helper range, and explain why the range must be a range rather than a typed list.

5. Make it reject invalid entries and show a help message.

Add an "extend it" section: a third level, several rows of dropdowns that each depend on their own parent, and how to keep the helper tab tidy. Add a troubleshooting table with columns Symptom, Cause, Fix.

Menu names and options can change, so mark every menu path [VERIFY]. Do not add scripts or add-ons. If I have more than 20 parents, tell me whether a different design would be easier to maintain.

Add a worked example with invented figures: Country with France, Spain and Italy as parents and 3 cities each as children.

Fill in before use

Optional: type your details and the prompt above updates. Nothing is saved or sent.

Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.

Invented example layout (tab named Lists)
A1: France | B1: Spain | C1: Italy
A2: Paris | B2: Madrid | C2: Rome
A3: Lyon | B3: Seville | C3: Milan
A4: Nice | B4: Valencia | C4: Turin

Parent dropdown in Tracker!B2: data validation, list from a range, Lists!A1:C1.
Helper in Lists!F2: =INDEX(Lists!A2:C4, 0, MATCH(Tracker!B2, Lists!A1:C1, 0))
Child dropdown in Tracker!C2: list from a range, Lists!F2:F4.

If B2 shows Spain, C2 offers Madrid, Seville and Valencia. [VERIFY] the exact menu path in your version.

• worksheet