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

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

Gord, Thank you for the information. It worked and I'm good to go. Thanks
again.

"Gord Dibben" wrote:

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

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.
--
Gary''s Student - gsnu200832


"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

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

"Gary''s Student" wrote:

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.
--
Gary''s Student - gsnu200832


"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