Forum Discussion
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 category column, the LOV for sub-category should be reflected accordingly to respected category.
For Example:
when i input Berth Maneuvering (column R) for category (LOV), LOVs for subcategory should reflect in the subcategory (column S)
figure 1
figure 2
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.
10 Replies
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.
i tried to use the alternative, i added categories but it couldn't reflect the subcategory that i added, hope you can help me with this.
i used function INDIRECT in the data validation for sub-category.
Julius575 But did you create named ranges for x,y,z, etc? And better to change the sub-categories in the example. Then you can at least see what you are looking at when you click in the drop-down in the cell next to "y". For example, use sub-categories y1 to y5, and z1 to z5.
- thank you Riny Van! it works
