Calculate pricing according to selections made

Hi all,

Some help with this will be greatly appreciated!!

I need to calculate a specific price according to selections made, I have the following:

Insulation (selection 1)(attached sheet : "System 1-3" cell B7)
-19mm
-25mm

Pipe Sizes (selection 2)(attached sheet : "Pricing" E12:V12 & E13:V13)
- 18 Sizes, each with 2 prices, one incl 19mm insulation and one incl 25mm insulation

I need to calculate total cost (attached sheet : "System 1-3" cell E12) which will be Length (D12) * Pipe Cost (Which will be determined by the 2 selections mentioned above)

Thank you

Several fields have not been clearly specified. Amend your sheet to show WHAT you expect to see WHERE you expect to see it.

You should have provided an actual sample calculation using the numbers from the workbook provided.
*
on 'pricing',
The numbers in c6:k6 look like tube/pipe diameters to me
A7 is labelled 'Length' but the data is currency/dollars - is that $ per 25 ft, 50 ft, 100 ft,...?
The data in P9:V9 looks like tee fittings...? $300 each (or, per 100?)
*
On "System 1-3",
-in B4, did you want a dropdown DV list from 'pricing' E9:O9?
-in B5, are you expecting manually input length in feet?