I'm not seeing this exact case in my search. The value I need to use for validation will be dynamically updated from a database in one LONG (thousands of values) list basically as TYPE|VALUE and the values may change often from the DB. But I don't want to have to create separate lists (say horizontally) for validation. For example the validation data would be like:
TYPE | VALUE
-----------------------
FRUIT | Apple
FRUIT | Orange
VEGGIE | Lettuce
VEGGIE | Carrot
What I'm hoping to find is way to set the range on a list validation almost like how SUMIF works with quasi SQL where clause. Ideally I could find a function(s) to put into the Source field of a list validation that would operate like =(select VALUE where TYPE="Fruit"). I'm not sure if this is a custom or list validation.
TYPE | VALUE
-----------------------
FRUIT | Apple
FRUIT | Orange
VEGGIE | Lettuce
VEGGIE | Carrot
What I'm hoping to find is way to set the range on a list validation almost like how SUMIF works with quasi SQL where clause. Ideally I could find a function(s) to put into the Source field of a list validation that would operate like =(select VALUE where TYPE="Fruit"). I'm not sure if this is a custom or list validation.