Drop down list help
 

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

Drop down list help
 

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

Drop down list help
 

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