How to make a variable dropdown list

[jade423]

I want to type in a customer name in A1 and have a dropdown list in B1 be populated with possible shipping addresses. would i use a vlookup connected to the drop down in some manner? The goal is to type in a name, select an address, and then print out the sheet to use as a shipping slip. Is this possible?

 

[lenze]

Go to www.contextures.com and look at the articles on Dependent List

lenze

 

[jade423]

Rather than taking all these steps for each customer, is ther a way to do this for all customers in a given spreadsheet?

So that whatever i put under Cust i get the relating Address dropdown?

 

[jade423]

this link helped great, thanks for your help!!!

http://www.contextures.com/xlDataVal15.html

It went into detail and gave a great example, i followed the steps and created an expandable, dynamic, variable dropdown list!!! Thanks again.