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

"scott" wrote:

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