View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default multiple data validation lookups

Have you seen Debra Dalgleish's notes here?:

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

The trick is to use named ranges for the various lists, with names
defined as the dependency chosen.

Hope this helps.

Pete


On Jun 30, 3:04*am, rlmeyers
wrote:
I'm able to to make a dependent drop down list that returns data from a list
based on one dependency, but need a drop down list that progresses and
returns a list based on two dependencies, then three, etcetera.
TYPE * *DATE * *SESSION
Attend *7/1/2008 * * * *10:30AM Attend
Attend *7/1/2008 * * * *7PM Attend
Attend *7/7/2008 * * * *7PM Attend
Pick-Up 7/1/2008 * * * *10:00AM Pick-Up
Pick-Up 7/1/2008 * * * *12:00PM Pick-Up
Pick-Up 7/3/2008 * * * *10:00AM Pick-Up
Deliver 7/4/2008 * * * *1:00PM Deliver
Deliver 7/4/2008 * * * *5:00PM Deliver
Deliver 7/5/2008 * * * *1:00PM Deliver

In the first drop down box, I chose from the type list Attend, in the second
drop down box, I chose 7/1/2008. *How do I create a third drop down box that
validates data from the first two? *and so on?