Dependent Drop-Down Lists - Free Excel Practice Online

This free, interactive exercise teaches you Dependent Drop-Down Lists in Excel through 5 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Lookup Functions track and works right in your browser - no Excel install, no download, and no signup.

Practising Dependent Drop-Down Lists this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.

What you'll practice in this Dependent Drop-Down Lists lesson

1. Dependent drop-downs are powered by INDIRECT, which turns text into a real cell reference. Cell A2 holds the text "B4". Type =INDIRECT(A2) in C2 to pull back whatever is in B4. - INDIRECT reads the text in A2 ("B4") and treats it as a reference, so it returns the contents of B4 - Carrot. Classic dependent lists point a validation list at =INDIRECT(A2) so the second menu follows the first.
2. The modern way (Excel 365) builds the dependent list with FILTER. The chosen category is in D2. Type =FILTER(B2:B6,A2:A6=D2) in E2 to spill only that category's items. - FILTER keeps every item in B2:B6 whose category in A2:A6 equals D2 (Fruit). It spills Apple, Banana, Cherry. A dependent drop-down then uses this spill range with a # as its source.
3. Change the parent choice and the list follows. The category in D2 is now Veg. Type =FILTER(B2:B6,A2:A6=D2) in E2 again. - Same formula, new result: with D2 = Veg, FILTER returns Carrot and Potato. Because it recalculates automatically, the dependent drop-down always matches the parent selection.
4. The parent drop-down should list each category once. Type =UNIQUE(A2:A6) in D5 to build a clean, de-duplicated category list. - UNIQUE removes duplicates from A2:A6 and spills Fruit, Veg. You point the first (parent) drop-down at this spill, then the child list reacts to whatever the user picks.
5. Finish by sorting the dependent list so it is tidy. Wrap the filter in SORT: type =SORT(FILTER(B2:B6,A2:A6=D2)) in E2. - FILTER returns the Fruit items (Apple, Banana, Cherry) and SORT puts them in A-Z order. Nesting dynamic-array functions like this is how a polished dependent drop-down is built in modern Excel.

Dependent Drop-Down Lists practice - FAQ