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?

You can create dependent data validation dropdowns, as described he

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


Mark wrote:
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
Contextures
http://www.contextures.com/tiptech.html

On May 9, 2:33 pm, Mark wrote:
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.