Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
VLOOKUP table is the usual way to go.
See Debra Dalgleish's site for instructions. http://www.contextures.on.ca/xlFunctions02.html Gord Dibben MS Excel MVP On Thu, 5 Feb 2009 08:12:20 -0800, Jason wrote: I am creating a validation to link to a list of account numbers. Each account number is has a company name, address, etc. As the user drops the list down to select an account number I would like to other cells to populate with ‘name of company,’ ‘contact,’ ‘address,’ and ‘telephone number,’ etc. Each of these items must populate in different cells. How do I link a drop down list validation in one cell to multiple cells that will populate after the user selects an account number? Thank you for your help. Jason |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Populating other cells based on a choice from a drop-down list | Excel Discussion (Misc queries) | |||
Populating a Data Validation List | Excel Discussion (Misc queries) | |||
Populating cells: Working in multiple worksheets | Excel Worksheet Functions | |||
Populating multiple cells from a single pull down | Excel Discussion (Misc queries) | |||
populating multiple cells | Excel Worksheet Functions |