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.

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.

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.

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.