Bottom line: Learn how to create cascading or dependent drop-down lists (also known as cascading validation) in Excel. This technique does NOT require named ranges. If you don’t mind using named ranges then there are a few links at the bottom of the page with solutions that will be easier to implement.
Skill level: Intermediate
Functions used: OFFSET, MATCH, COUNTA, COUNTIF, INDIRECT Continue reading