Validation list populating multiple cells


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
 
Ad

Advertisements

G

Gary''s Student

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.
 
J

Jason

Thank you Gary''s Student, the information worked and I am well on my way.
Thanks again. Jason
 
Ad

Advertisements


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

Top