Drop down lists

C

ConfusedKip

I am new to using Excel 2007. I have figured out how to create a drop down
list using Data Validation but I need help making it function the way that I
need it to in a sales order.
I created the original drop down list of "customers."
If Customer "A" is chosen on that list, I need Customer "A"s address to come
up on the sales order as well.
Can someone eplain how I would go about setting this up?
 
J

John C

I am assuming you have a table of customers, and so long as the first column
in that table of customers is the customer name then use the VLOOKUP function.
Say the address is in the 2nd column of the customer table:
=VLOOKUP(A1,custtable,2,FALSE)

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help: Keeping Data 1
Drop down list 1
look up formula 3
Filtered drop down list 2
Drop Down List 3
Conditional Drop Down List 2
Data Validation & Drop-Down Lists 4
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Top