Data Validation using a table

[JBranter]

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.

 

[T. Valko]

See if this helps:

http://contextures.com/xlDataVal02.html

 

[Luke M]

I believe you're describing dynamic validation. See site for help/guidance.

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

 

[JBranter]

Perfect

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!*