Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down lists
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. -- John C "ConfusedKip" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Lists | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
drop down lists | New Users to Excel |