I am trying to make an Excel sheet that my customers can enter a few pieces of information and get their cost for a product. In Sheet2, I have a tool I use to calculate the price of some Studs. Because the price varies depending on the diameter of the material, I have a template for each size stud (1/2", 5/8", 3/4", etc.) I enter the Quantity and the Length and then the price is calculated automatically. I don't want my customer to see Sheet 2. Instead, I want to figure out a way for the customer to use something like what is on Sheet 1, where all they have to enter is the Quantity, Diameter and Length. I want the Diameter to be based on a list, which I know how to do. What I can't figure out is how after the Length is entered to get it to calculate the price.