| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
vlookup and drop-box
Wonderful, Thank you
"Pete_UK" wrote: You need dependent data validation. Debra Dalgleish shows how to set it up he http://www.contextures.com/xlDataVal02.html Hope this helps. Pete On May 16, 12:23 am, Tanya wrote: Hi I would like to have a drop down box which looks at a list on another sheet [list name could be 'spell' OR 'math'] which is dependant upon the value in another cell. i.e. A1 has a drop box with values 'spelling' and 'maths' B1 has a drop box with reference to two tables 'spell' and 'math' Is this possible or beyond the scop of Excel? The reason I want to have two lists in B1 is to have less to scroll through [my lists will be quite long]. Note: I have heavily simplified my scenario, I hope it makes sence. Kind Regards Tanya |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup and drop down lists | Excel Discussion (Misc queries) | |||
| Drop-down lists in vlookup | Excel Discussion (Misc queries) | |||
| Can I add a drop-down list to a Vlookup? | Excel Worksheet Functions | |||
| Can I add a drop-down list to a Vlookup? | Excel Worksheet Functions | |||
| Drop Down List + VLOOKUP | Excel Worksheet Functions | |||
Threaded Mode
