Conditional data validation (using a filtered range?)

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top