Forum Discussion
Solved
How to Create LOV with category with corresponding sub-category
Hi Excel Community, Hope you can help me with my concern, i have here my list of values for category and sub-category for figure 1, all i want is to reflect in figure 2, when i input in the categ...
Julius575 Added a workbook with two examples of Data Validation. The first one uses a structured table with all the options and dynamic array functions UNIQUE and FILTER. The second example uses a more traditional method with named ranges, though it's less flexible and requires more maintenance.
Julius575 Added a workbook with two examples of Data Validation. The first one uses a structured table with all the options and dynamic array functions UNIQUE and FILTER. The second example uses a more traditional method with named ranges, though it's less flexible and requires more maintenance.
thank you Riny Van! it works