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.