EXCEL 2007 help with building quote sheet

I am building a document for the company I work for to assist with getting customers quotes quicker. I have several things though that I have never done before that I need to figure out and would appreciate any help as I have been tasked with this job regardless of my knowledge.

1.) I need to have a drop down box with part names that when selected will pop up a price in a separate cell. I have the drop down box created using "Data Validation">List with the Source being a column of cells on worksheet 2. It's the second half of this I am struggling with. I had used an IF statement for one option that only had 3 variables with two of them being the same price. This worked for this situation but won't work to my knowledge on 3+ variables with 3+ prices. The formula I used was (primary distribution is the name of the grouping:

=IF(A14="primary distribution","$1,000","$750")


The second thing I need to be able to do is have a 4x3 table with the following headers:

Qty.
Part Number & Description
Single Unit Cost
Extended Cost

The quantity can be <blank>,1, or 2 but the sum of the two rows can not exceed 2.

the part number & description is a drop down with 3+ variables.

the cost will be filled in automatically based on the single unit cost from the part number & description column.

the extended cost will be filled in automatically based on quantity x single unit cost




Thanks in advance for any help or direction with this as I am pretty lost. If something is not clear let me know and I am happy to provide more details.