software

Is it possible to automatically populate a cell, for ex. quot;cost per
unitquot;, 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.--
sarah1997
------------------------------------------------------------------------
sarah1997's Profile: www.excelforum.com/member.php...oamp;userid=30498
View this thread: www.excelforum.com/showthread...hreadid=501507Hi, Sarah. I have an tutorial on just this thing.
www.officearticles.com/tutori...soft_excel.htm

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

quot;sarah1997quot; gt; wrote
in message ...
gt;
gt; Is it possible to automatically populate a cell, for ex. quot;cost per
gt; unitquot;, when a selection is madde from a drop down list (data
gt; validation) created from an inventory list of products? On my invoice I
gt; want to have drop down box with all products, select product from list,
gt; have price per unit automatically populated, enter manually number
gt; used/sold, have formula calculate total price for total units...I just
gt; can't figure out the auto population part. My product inventoru list
gt; has about 250 items with varying prices. I copied the product list w/o
gt; any prolems to the data validation part of the invoice. Any help/tips
gt; advice welcome. Newbie.
gt;
gt;
gt; --
gt; sarah1997
gt; ------------------------------------------------------------------------
gt; sarah1997's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30498
gt; View this thread: www.excelforum.com/showthread...hreadid=501507
gt;
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

www.contextures.com/xlFunctions02.html

And for instructions for a sample order form:

www.contextures.com/xlOrderForm01.html

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