Multi Sheet Excel Calculations with Drop down
===

I have been trying this all day now, and I am about ready to give up and write a .net program... 

My current layout is as follows:

Sheet 1 (Materials in inventory)

 - Material Name
 - Original Cost

Sheet 2 (current project)

 - Material Name (data validation drop-down)
 - % used
 - Cost (calculated from % used * sheet1's original cost)

I would think that it would be easy to find the "original cost" cell from sheet2 based on the drop down menu, but I cant figure it out for the life of me. I do have the data validation working, but I cant seem to access the "original cost" cell based on the data validation drop-down.

What kind of formula would I need to use to access the information in sheet1 based on the drop-down menu in sheet 2?