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 :)