Use validation to create dependent lists

Photo of Bill Jelen By Bill Jelen

Bill Jelen is the author of 24 books on Microsoft Office Excel. He is a regular guest on TechTV with Leo Laporte and the host of MrExcel.com, which includes more than 300,000 questions and answers about Excel.


Learn how to use the INDIRECT function and data validation to set up two dropdown lists, where the choices in the second list change based on what is selected in the first list.

Read Article button

This article is an excerpt from Learn Excel 97-2007 from MrExcel by Bill Jelen. Buy the print edition or download a free e-book edition from MrExcel.com.

Other articles by this author

Excel 2007

Excel 2003

 
 
Applies to:
Excel 2007