I am making a cost calulator for a machine made of 10 basic items, but of different lenghts. The machine has 40 pieces all made from the 10 basic items (but different lengths). I have a list of items in one column with thier associated cost per foot in another column. I made a drop down list within my spreadsheet and I would like to be able to select the item from the drop down and have the associated cost automatically appear in the cell adjacent to the item. THen I can multiply the length of the piece by the (automatically populated) cost per foot to return the cost for that specific piece. Any ideas? thanks, aaaron