Debra Dalgleish has a web page dedicated to creating an order form using
drop down lists and Vlookup to fill in additional information:
http://www.contextures.com/xlOrderForm01.html
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"scott" wrote in message
...
I have created an order sheet with excel2003.
Is it possible to select a customer from a drop down list and the customer
number be placed automatically in another box (example - customer name in
A1
and customer number in A2)?
Your help is greatly appreciated :)