Hello everyone. I'm currently having an issue figuring out the best way to create a quote worksheet for my small business. A regular worksheet won't work as my items aren't just a total sum of all products but rather have multiple variables that can alter the price. I'm using dropdown lists to select the input, and would like for those inputs to create a price. For example: If the Size = 1G, Material = Plastic and Quantity = 1,000 the price would equal $500. But if Size = 1G, Material = Plastic and Quantity = 2,500 then the price would be $1,000. You can see my lists below. Please let me know if I need to provide more detail.

Inputs
Size: 1G
Material: Plastic
Quantity: 1,000

Lists
Size:
1G
3.5G
7G
14G
28G
Custom

Material:
Plastic
Paper

Quantity:
1,000
2,500
5,000
10,000
20,000
Custom


Thanks in advance!
Jake