I have a spreadsheet that I use to calculate the cost of a product. It was originally designed to be used for one type of material, that's called B7. But I would like to use it to calculate other materials as well, (SS,Low Carbon) Currently if you go to the tab called Stud Price Calculator and enter in the quantity, size (drop-down list) and length, it will calculate the price and weight. It does this in Sheet!Calculation. I guess I would need to add a drop down box in the first tab and have the user select which material, that I understand. What I'm having trouble figuring out is how do I tell it to calculate based on the prices for the different material?