To create conditional lists, complete the following procedures. Similarly, when you select a city in Column C, only the street names of that city will be displayed in column D. If you select Germany, only German cities will be displayed in the drop-down list in Column C. If you select Netherlands in the drop-down list in column B, only Dutch cities will be displayed in the drop-down list in Column C. In this example we’ll create the following table:Ĭolumns B, C, and D contain drop-down lists. By using the INDIRECT function, you can then create additional drop-down lists that are conditional to the first drop-down list.
In Excel 2007 (and earlier), it’s possible to create a drop-down list. Today’s author is Reinout Dorreboom from the Netherlands, a Technical Consultant at Getronics, where he has worked with Office applications for many years, and where his Microsoft Certified Training skills enabled him to help other people get up to speed with Excel.
