Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please with Dropdown lists and Vlookup
How can I integrate using a multiselect dropdown list and vlookup function?
I have gone to "Contextures" website but do not see this type of example. I am trying to setup a form with a couple of list boxes where if I select the first box and select an item(s) they will be filled in the adjoing cell and the other list boxes will be populated with the data pertaining to the item selected in the first list box. Any help or reference to any site will be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please with Dropdown lists and Vlookup
Hi Totally Confused,
You say that you have looked at the Contextures site, but did you look at Debra Dalgleish's Dependent Lists page: http://www.contextures.com/xlDataVal02.html and her Dependent Dropdowns from a Sorted List page: http://www.contextures.com/xlDataVal13.html See also xlDynamic's Dependent Dropdowns page: http://www.xldynamic.com/source/xld.Dropdowns.html --- Regards, Norman "TotallyConfused" wrote in message ... How can I integrate using a multiselect dropdown list and vlookup function? I have gone to "Contextures" website but do not see this type of example. I am trying to setup a form with a couple of list boxes where if I select the first box and select an item(s) they will be filled in the adjoing cell and the other list boxes will be populated with the data pertaining to the item selected in the first list box. Any help or reference to any site will be greatly appreciated. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help Please with Dropdown lists and Vlookup
Give Debra's site a look. Might be the beginning of what your are trying to
do. http://www.contextures.on.ca/xlDataVal02.html Look under Dependant lists section. HTH Regards, Howard "TotallyConfused" wrote in message ... How can I integrate using a multiselect dropdown list and vlookup function? I have gone to "Contextures" website but do not see this type of example. I am trying to setup a form with a couple of list boxes where if I select the first box and select an item(s) they will be filled in the adjoing cell and the other list boxes will be populated with the data pertaining to the item selected in the first list box. Any help or reference to any site will be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - need a function to compare lists | Excel Worksheet Functions | |||
Vlookup from lists | Excel Discussion (Misc queries) | |||
Vlookup - Comparing two lists in different worksheets | Excel Worksheet Functions | |||
Vlookup | Excel Worksheet Functions | |||
Problem with VLOOKUP and drop-down lists! | Excel Worksheet Functions |