Forum Discussion
dhazan29
Jul 07, 2021Copper Contributor
Data Validation List Using Array and Constant
Hi! I am working on doing a dependent data validation. I finally have gotten the dependent list working (thanks to this forum!) using this "List" criteria: ='Dynamic Route'!$B$25# In addition to...
Riny_van_Eekelen
Jul 08, 2021Platinum Contributor
dhazan29 See the picture below. The example filters the second column based on values in the first PLUS the row that contains "Overall" in the second column. would that work for you?