Hello-
I'm no expert and have been racking my brain but can't seem to figure out my validation list issue. I'm trying to conceptualize how I can have dependent and independent validation lists. I'm trying to create a workbook where one validation is a subset of the previous with the third validation being a subset of the subset (Market Segment, Product Family, CBook 4.xlsxustomer). I cannot use name manager because some of the values are shared where, for example, depending on the segment, the same product family will have different customers. Additionally, the name manager option forces one or both of the previous data validation lists to be populated. Essentially the goal is to allow a user to filter report results with similar functionality of a pivot table, where the combination of the 3 validation lists will yield unique results. I've drawn up the general idea as I believe I'll need some helper cells to make this work, but just cannot see the big picture as to how to make 3 dynamic validation lists through a formula. Ultimately I need each validation list to reference a range whose formula's results are dependent on the selection in the other two validation lists. Perhaps there is a simpler solution and I've just stared at this too long to see it and I'm also open to any other paths that would get me closer, but I cannot seem to make progress with this issue I'm faced with.
Any help would be appreciated as I've searched for a solution without success.
Thanks in advance.
Joe
Bookmarks