It doesn't matter if the order is the same in the master_list and the dependent_list, but identical values in the master column of the dependent_list must be together. The dependent_list must be ordered by the values in the first column (master values).The master_list is ordered as you wish values appear in the dropdown list.I have named heading to the cell above the dependent_list (for example, if the dependency table starts in A2, the heading is A1.I have named the list of look-up values (this is, the values in the first column) as dependent_list.The first column contains the master/look-up value and the second the dependent values. Create a table or range somewhere in your book with two columns.I have named the range with the values master_list.Create a table or range somewhere in your book with one column with the master values.If you have doubts to do it, read Use names in Excel formuas Take into account that I always use names to refer to ranges instead of references, to improve readness. To do that, I suppose there are other ways but this is what I usually do: I guess what you want are two dropdown lists, the second depending on the value selected in the first one? (please elaborate your questions some more).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |