You can use a VLookup formula to return the cost per unit when a product
is selected. There's information in Excel's Help, and he

http://www.contextures.com/xlFunctions02.html

And for instructions for a sample order form:

http://www.contextures.com/xlOrderForm01.html

sarah1997 wrote:
Is it possible to automatically populate a cell, for ex. "cost per
unit", when a selection is madde from a drop down list (data
validation) created from an inventory list of products? On my invoice I
want to have drop down box with all products, select product from list,
have price per unit automatically populated, enter manually number
used/sold, have formula calculate total price for total units...I just
can't figure out the auto population part. My product inventoru list
has about 250 items with varying prices. I copied the product list w/o
any prolems to the data validation part of the invoice. Any help/tips
advice welcome. Newbie.:)




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html