Hey all,
Hoping you can help. Im not too excell savvy so please bear with ne as i try to explain this.

I am in the process of attempting to create a spreadsheet to assist in quoting. I have sorted out drop down lists however what i am trying to achieve is a selection in the dropdown list have a value, for example select 6mm clear in a dropdown list has a value of 25 so when cells are added together then multiplied by the selected dropdown it spits out a total cost.

Hope this is understandable