Jean, You just went way over my head... Can you show me a sample file...
Thanks for the quick response.

"Jean-Guy" wrote:

Hi,

Create a table with all the info then use a VLOOKUP function to retrieve the
info, so if A1 is your drop down menu then.

=VLOOKUP($A$1,your table range,2,0)

the 2 in the formula represent the column number in the table, you can
replace it with either a COLUMN function or ROW function to make it easier to
copy across or down.
e.g.
=VLOOKUP($A$1,your table range,COLUMN(B1),0) ...copied across
=VLOOKUP($A$1,your table range,ROW(A2),0) ....copied down

B1 and A2 refers to the second column in the table.... don't forget to make
your table range aboslute ($B$1:$F$100) or you can name your table and use
that name in the forumula instead.

HTH
Jean-Guy

"MMANDIA" wrote:

I have created a basic Work Order with drop downs, worls great. Now I would
like to add customers to a worksheet drop down. Once I select the customers
name, I would like to fill in address, Phone, Customer ID, etc. in work order
to print invoice.
I will put all this info into a worksheet in the workbook.
How can I do this in Excel.