S
Simon
I have a multi-column list of data that I would like to use for conditional
list validation in another place. Something like:
# Name Type
1 Apple Fruit
2 Banana Fruit
3 Dog Animal
4 Rose Flower
5 Orange Fruit
6 Cat Animal
7 Horse Animal
Example: in another place I would like to set up a List type validation that
does the equivalent of "valid values for this cell are those where the Type
cell in the Lookup range equal 'Animal'". I would also like the drop down
list to be available.
This is basically so I don't have to define lots of different ranges
(Animals, Fruit, etc.) for validation, and the full list is not necessarily
in Type order.
Any ideas if I can put a formula in Data->Validation to achieve this?
list validation in another place. Something like:
# Name Type
1 Apple Fruit
2 Banana Fruit
3 Dog Animal
4 Rose Flower
5 Orange Fruit
6 Cat Animal
7 Horse Animal
Example: in another place I would like to set up a List type validation that
does the equivalent of "valid values for this cell are those where the Type
cell in the Lookup range equal 'Animal'". I would also like the drop down
list to be available.
This is basically so I don't have to define lots of different ranges
(Animals, Fruit, etc.) for validation, and the full list is not necessarily
in Type order.
Any ideas if I can put a formula in Data->Validation to achieve this?