Defining dependent dropdown lists in Excel 5 December 2020 by Peter Tormay Data validation drop down lists are an excellent way to ensure data consistency. This becomes even more important when you have hierarchical, dependent data. This article describes one way to establish dynamic drop down validation lists.