Drop down list help

[scott]

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

 

[chefmike]

Yea its possible, In A2 you would have a vlookup formula.

 

[RagDyer]

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