Calculating a total price based on variables in a separate chart

Hi guys,

New to Excel. Using version 2010 on a PC.

A coworker asked me to help him out with some pricing today. Not really my field but I figured I could Google the problem. Couldn't find it so I figured I'd come here to be more specific.

I need to calculate some pricing for a print order we are making based on different variables. There are two sheets. The first one is calculating the price for that specific company and their needs. The second sheet has our pricing table on different variables.

Where it says "Price of Print" and "Price of UV" I need a formula for those boxes that will take the data right above and compare it to the right pricing on the second sheet. The total print cost already has a formula to include sum of the cells B11:B13.

Can anyone help me out? (pictures are attached)excelprint2.jpgexcelprint1.jpg

EDIT: I noticed people attached their excel files. PricingSheetforPvals.xlsx

With index / match

See the attached file.

Please reply.