View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
rlmeyers rlmeyers is offline
external usenet poster
 
Posts: 4
Default multiple data validation lookups

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?