Might be something here at Debra's site that you could use.

http://www.contextures.on.ca/xlDataVal02.html#TwoWord

Create a two-word DV list then have a dependent list off that.

http://www.contextures.on.ca/xlDataVal02.html which is probably the "resource"
you found.


Gord Dibben MS Excel MVP

On Thu, 21 Feb 2008 16:17:01 -0800, Ayo wrote:

As my subject line implies, I am trying to figure out how to change a
validation list based on a selection (or selections) from another validation
list. I found a resource that shows how to do it for 2 list, but I have 3
list and one of them is based on the selections from the other two.
So what I need help with is how to setup a validation list that changes
based on the selections from two other validation lists. Any help will be
greatly appreciated. This is a top priorty for us right now.
Thank you.