This site describes what you're wanting

http://www.contextures.com/xlDataval02.html
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steve" wrote:

I'm able to create lists and validation per contextures.com for one cell. But
now I'd like to create a validation for the next cell based on the results of
the first validation results. Cell C9 provides 2 options. Cell C13 provides
options based on input selected from C9. Now I want to create a function(?)
or validation for cell C15 based on a combination of C9 and C13.
--
Steve