Dependent Lists: Category → Item with INDEX/MATCH
This lesson is part of the course
In this lesson
You check that every order line's item belongs to its category – the logic of a dependent (cascading) drop-down – and build the INDEX/MATCH pieces of its list source.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Number & Date Rules as Check Formulas Locked
- List Rules: Allowed Values with COUNTIF & MATCH Locked
- Dependent Lists: Category → Item with INDEX/MATCH Locked
- Text Length & Pattern Checks: LEN, LEFT, SEARCH Locked
- Duplicate Prevention: COUNTIF & COUNTIFS Rules Locked
- Cross-Field Rules: End ≥ Start and Shares = 100% Locked
- Input Form with Error Messages & an Error Summary Locked
- Template Protection Checklist & Completeness Dashboard Locked