Validation of multiple selections

[Guest]

What I want to do is a IF then statment to choose which validation area i
want to choose from. is this possible? or what is the best way to do this?

 

[Debra Dalgleish]

You can create dependent data validation dropdowns, as described here:

http://www.contextures.com/xlDataVal02.html

 

[Adhiza]

What I want to do is a IF then statment to choose which validation area i
want to choose from. is this possible? or what is the best way to do this?

Another way of leveraging the example that Debra posted in the link is
an if statement in the data validation. If you have each section as a
named range then you could write a statement as follows for data
validation (using the fruit and veg example from the link in Debra's
Post)

=if(foodSelected ="Fruit",Fruit,if(foodSelected="Vegetable",Vegies,"-
select Food Type"))
Since foodSelected is your first dropdown you can evaluate against it
to populate your next drop down choice. Also as you can see this kind
of set up will allow for a default in the dropdown.