Debra Dalgleish has a sample order form that you can download.
It has drop down examples together with Vlookup formulas that should answer
all your questions.
http://www.contextures.com/xlOrderForm01.html
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"MMANDIA" wrote in message
...
I would like to send you my file so you can see what I have.
Mike
"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.