Here's my scenerio:

Sheet 1 is the main page with all the information (a quotation with material
and price breakdown). In columns A & B data has to be entered in manually.
Each row in column C is set as drop down menus created by an Item List
created in Sheet 2 (done by Data Validation).

Now, in Sheet 2 where I have all the items listed, in another column I have
listed the price for each item. For example A1=Part Number, B1=Part
Description, C1=Cost of Item.

Is there a way to automatically plug in the price listed on C1 of Sheet 2
onto Sheet 1 when an item is selected from the drop down menu?

Can anybody help??....Please...