Excellency AcademyOpen the appFinanceTier 218 minadvanced
Dependent Dropdowns: Account and Sub-account
Restrict the sub-account dropdown to only the sub-accounts that belong to whichever account was chosen in the same row.
What you will learn
- Build a second dropdown whose list depends on a choice made in another cell
- Explain why one flat list of every sub-account lets an entry be paired with the wrong parent account
- Use a named range or INDIRECT/OFFSET-style approach to drive the dependent list
Excel skills
Dependent Data Validation · Data Validation
The task
Column A picks one of 3 accounts (Revenue, Expenses, Assets). Column B needs its own dropdown for that row - but restricted to only the sub-accounts that actually belong to whichever account was chosen in column A on the same row, not one flat list of every sub-account from every account.
You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.