Validation of multiple selections
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? |
Validation of multiple selections
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 |
Validation of multiple selections
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. |
All times are GMT +1. The time now is 02:02 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com