Forum Discussion
How do I create a validation dropdown that uses the FILTER function?
- May 19, 2023
RedNectar I independent of Subodh_Tiwari_sktneer came up with a similar solution but I think mine is slightly more dynamic (i.e. you don't need to fill down). So I also create a lookup list but dynamically so it will expand with the table size. The data validation then looks at the corresponding row of that table, however, it looks at the full table width meaning shorter lists have lots of extra blanks at the end.
Please look at the sheet called "Validation" in the attached which contains a setup for the validation lists and then on the attribute_tab sheet, the first validation uses =Validation!$A2# as the source for the validation list which is then copied down. See if this helps.
RedNectar I independent of Subodh_Tiwari_sktneer came up with a similar solution but I think mine is slightly more dynamic (i.e. you don't need to fill down). So I also create a lookup list but dynamically so it will expand with the table size. The data validation then looks at the corresponding row of that table, however, it looks at the full table width meaning shorter lists have lots of extra blanks at the end.