| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation using a table
I am trying to set up data validation using multiple columns, but not sure
how. Example - trying to limit choices of items sold as tiles, tools, plants. Under tiles, the choices could be red, grey or black;the tools would be hammer, saw, screwdriver and plants would be pansies, daisies, tulips. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation using a table
See if this helps:
http://contextures.com/xlDataVal02.html -- Biff Microsoft Excel MVP "JBranter" wrote in message ... I am trying to set up data validation using multiple columns, but not sure how. Example - trying to limit choices of items sold as tiles, tools, plants. Under tiles, the choices could be red, grey or black;the tools would be hammer, saw, screwdriver and plants would be pansies, daisies, tulips. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation using a table
I believe you're describing dynamic validation. See site for help/guidance.
http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JBranter" wrote: I am trying to set up data validation using multiple columns, but not sure how. Example - trying to limit choices of items sold as tiles, tools, plants. Under tiles, the choices could be red, grey or black;the tools would be hammer, saw, screwdriver and plants would be pansies, daisies, tulips. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Data Validation using a table
Perfect
"Luke M" wrote: I believe you're describing dynamic validation. See site for help/guidance. http://www.contextures.com/xlDataval02.html -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "JBranter" wrote: I am trying to set up data validation using multiple columns, but not sure how. Example - trying to limit choices of items sold as tiles, tools, plants. Under tiles, the choices could be red, grey or black;the tools would be hammer, saw, screwdriver and plants would be pansies, daisies, tulips. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Table Column for Data Validation List | Excel Discussion (Misc queries) | |||
| Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
| Data validation list from table | Excel Worksheet Functions | |||
| Data Validation with multiple table selection | Excel Discussion (Misc queries) | |||
| Table Array in VLOOKUP Relies on Data Validation | Excel Worksheet Functions | |||
Linear Mode
