Forum Discussion
How to Create LOV with category with corresponding sub-category
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.
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.
i already did to change sub-categories,
when i do the data validation, there's an error occurred pls see below screenshot
Hi Riny,
Attached file, already plot data for sub-cat in the "option" sheet.
kindly check "selection" sheet on the sub-category with the red-highlight it doesn't shows LOV for sub-cat.