Conditional Dropdown Menus
Posted by Rick Behrens on November 20, 2001 11:30 AM
I would like to use the validation feature to create a "picklist" or dropdown menu for a cell. That par is easy, but the catch is that I want the choices in the cell to be determined based on the criteria from another cell by searching another worksheet to find all of the choices that meet that criteria.
For instance, let sheet 1 contain a column of states (A) and a column of cities (B) where there are several cities for each state. On sheet 2, let cell A:1 be used to enter a state. I would like cell B:1 to be a picklist of all of the cities in that state.
Thanks for the help.