data validation lists and invoices

[sarah1997]

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

 

[Anne Troy]

Hi, Sarah. I have an tutorial on just this thing.
http://www.officearticles.com/tutorials/order_form_or_invoice_form_in_microsoft_excel.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

 

[Debra Dalgleish]

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

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

And for instructions for a sample order form:

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