farelopx.blogg.se

We go to Formulas/Create From Selection and choose Left Column.

We want to name the range where the French Cities are France and so on. Step 2: Creating the named rangesīefore we can define the dropdown in C5, we must create a few named ranges so that Indirect will point to the right range. It’s very important to understand that with using Data Validation to create the dropdown, and accepting all defaults under Error Alert you have also effectively limited the input into that table to only the values from the dropdown. So now you get a dropdown list in cell C3 where you can choose any of the countries. In the dialog box you get you choose List under Allow: and point to the cells containing the names of the countries in the Source field. So standing on C3 you go to Data/Data Validation Just for clarification I will explain how to create a dropdown list in cell C3 using basic Data Validation. Step 1: Dropdown list with Data Validation The first being the INDIRECT function and the second is using the named ranges. To achieve this we will use Data Validation with two additions. So if for instance someone picks France in C3, the dropdown menu in C5 has to give Paris, Lyon and Marseille, but if Slovenia is choosen in C3, Ljubljana, Maribor and Koper are in a dropdown in C5. But, and here’s the catch, the dropdown in C5 has to be relative to whatever is choosen from the dropdown in C3. Now we wish to have two dropdown menus, one in cell C3 and one in cell C5.

We will start with the following workbook and data…

First let’s take a look at what we are trying to accomplish. In this article I will show you how to create dependent Dropdown lists using Data Validation and an Excel function called INDIRECT. Creating a dependent or linked Dropdown list