Trying to work out a Multi Selection Cost calculator

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

Siva, This is excellent. Testing it works, though noticed an issue, which I believe is due to my design. So the Material list, when I select Wood (for instance), is there a way to have the Material details be a drop down list based on what I picked in Materials? Formula should not be an issue, was just looking for an easier way, than typing. Just seems that Excel did not like a Drop down having three different groups in it.

Thanks again
Brian

Siva, Never mind, found a way to do with by doing a Multi part formula, based on your above. Thanks dude.