![]() If the user selects "Fruit", they see a list of fruits, if they select "Nut", they see a list of nuts, and if they select "Vegetable", they see a list of vegetables. In the example shown below, column B provides a dropdown menu for food Category, and column C provides options in the chosen category. Read on to see how to create dependent dropdown lists in Excel. In the second exercise you have to enter the missing number to complete the sum correctly. In the first exercise you have to draw a line from the sum to the correct answer. ![]() For the 4 times table worksheet you can choose between three different sorts of exercise. ![]() This may sound complicated, but it is actually very simple, and a great example of how INDIRECT can be used. Click on the worksheet to view it in a larger format. They are created with data validation, using a custom formula based on the INDIRECT function and named ranges. These kind of lists are called dependent dropdowns, since the list depends on another value.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |