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