Read on to see how to create dependent dropdown lists in Excel. ![]() This may sound complicated, but it is actually very simple, and a great example of how INDIRECT can be used. ![]() 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 |