Trying to work out a Multi Selection Cost calculator

[robiton]

Hello,

Attached is a sample document (The doc this is part of is very large with other unrelated data, also simplified this to all be on one tab.). Final doc, the material drop downs will be on my Lists tab in my other document.

Trying to work out the formulas and drop downs, so that I can calculate my cost on things I am working on, so I know what I have to sell them for to break even or make anything.

The goal is for the the first 3 items to be drop downs from a list. I would select which "main part", the "Material Type", and the "Material details", then it would fill in the cost columns, and calculate it in the Total cost for me.

So as an example if I selected Main part 1, Material Wood, then Selected Cherry, it would put in costs $2.50, $2.00, and $.50, to yield me a total of $5.

Please let me know if there is other details I can offer to help.

Thanks