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
|