| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Many to One Lookup Match in Drop Down List
Hi,
I have 1000 customers, with 1 to 6 ship-to cities for each of the customers. I have 1 pull down where a user picks a customer. Problem: In a second cell, i would like to lookup up the multiple ship-to cities for that customer selected in the first cell, and have the user be able to choose from a pull down the 1-6 cities that matched the first cell. I have done this in Access, but can't figure it out in Exel.... Please let me know. Thanks, Joan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Many to One Lookup Match in Drop Down List
have a look at this site:
http://www.contextures.com/excelfiles.html there are some good working examples you can download for free - may not be complete anwser for what you want but should set you off in right direction. -- jb "colorado808" wrote: Hi, I have 1000 customers, with 1 to 6 ship-to cities for each of the customers. I have 1 pull down where a user picks a customer. Problem: In a second cell, i would like to lookup up the multiple ship-to cities for that customer selected in the first cell, and have the user be able to choose from a pull down the 1-6 cities that matched the first cell. I have done this in Access, but can't figure it out in Exel.... Please let me know. Thanks, Joan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Many to One Lookup Match in Drop Down List
Thank you very much, John. I am sifting through the website, hopefully I'll
find a close fit! Thank you for sending me a link to this resource! Sincerely, Joan "john" wrote: have a look at this site: http://www.contextures.com/excelfiles.html there are some good working examples you can download for free - may not be complete anwser for what you want but should set you off in right direction. -- jb "colorado808" wrote: Hi, I have 1000 customers, with 1 to 6 ship-to cities for each of the customers. I have 1 pull down where a user picks a customer. Problem: In a second cell, i would like to lookup up the multiple ship-to cities for that customer selected in the first cell, and have the user be able to choose from a pull down the 1-6 cities that matched the first cell. I have done this in Access, but can't figure it out in Exel.... Please let me know. Thanks, Joan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use v lookup from a drop down list | Excel Worksheet Functions | |||
| MAtch drop down list selection to data sheet | Excel Worksheet Functions | |||
| Drop-down list with Lookup function? | Excel Discussion (Misc queries) | |||
| "Suggest a match" from a list or drop down. | Excel Worksheet Functions | |||
| Using a drop-down list to lookup | Excel Programming | |||
Linear Mode
