ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Help Please with Dropdown lists and Vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/58271-help-please-dropdown-lists-vlookup.html)

TotallyConfused

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.

Norman Jones

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.




L. Howard Kittle

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.





All times are GMT +1. The time now is 09:09 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com