Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation lookups
I've seen that and still can't figure out how to apply multiple dependencies...
Have you got any ideas on the data validation fomula? "Pete_UK" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
multiple data validation lookups
In Debra's example she has Fruit and Vegetable as the first two choices, and
then the list of fruits (Apples, Pears etc) is given the name Fruit. Taking this example further, suppose you wanted to distinguish between different apples (Red, Green, Eating, Cooking, Sweet, Tart etc), then you would have to name this list Apples, and then apply the same concepts as discussed on that page of Debra's. Hope this helps. Pete "rlmeyers" wrote in message ... I've seen that and still can't figure out how to apply multiple dependencies... Have you got any ideas on the data validation fomula? "Pete_UK" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MULTIPLE LOOKUPS FOR MULTIPLES | Excel Discussion (Misc queries) | |||
sum multiple lookups? | Excel Worksheet Functions | |||
Validation and Lookups | Excel Discussion (Misc queries) | |||
Multiple V Lookups | Excel Worksheet Functions | |||
Multiple Lookups | Excel Discussion (Misc queries) |