Validation list populating multiple cells

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

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
 
Use VLOOKUP()

Once the user has filled A1 using the pull-down, each of the secondary cells
can contain a VLOOKUP formula based upon finding the value in A1 in a table
and looking across to get the correct data for that A1 choise.
 
Thank you Gary''s Student, the information worked and I am well on my way.
Thanks again. Jason
 

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

Data validation list using filtered range 3
How do I auto populate based on a drop down list? 0
How can I populate a drop down list from Data Validation? 1
empty cells in the drop down list 7
Locking Cells in an Automated SpreadSheet 1
Create Drop Down Box populated by a List 1
Filling Out Cells Based on Data Validation 1
Need to populate data from different sheet. 1

Back
Top