I need help with what I'm guessing requires the VLookup function.

Here's what the spread sheet needs to do —

Column 1 = QUANTITY
Column 2 = PRINT TYPE with pull down menu to choose Black/White or Color print with respective cost per type of print
Column 3 = PAPER TYPE with pull down menu to choose one of the following Bond/Text Uncoated/Text Coated/Heavy Text Uncoated/Heavy Text Coated/Cover Uncoated/Cover Coated/Cast Coated
Column 4 = Total — QUANTITY X (PRINT TYPE NET COST EACH+ PAPER TYPE NET COST EACH)

Here's the details:
— show me how to add the net prices for the black/white or color print, each
— show me how to add the net prices for each type of paper
— show me how to make the total reflect the following mark-ups:
for quantity up to 99: (print type net cost + paper type net cost) 300%
for quantity up to 100-499: (print type net cost + paper type net cost) 280%
for quantity up to 500-999: (print type net cost + paper type net cost) 250%

I hope I've explained this well enough for you to understand what I'm looking for. Your help is appreciated.