Conducting Conditional Calculations

Ive put that in the first text mate: So for example:

Safety Window Film (PRODUCTWIDTH) x (PRODUCTLENGTH

This is a (PRODUCTWIDTH) wide roll of safety window film and is (PRODUCTLENGTH) in length

Product Details
Width (PRODUCTWIDTH)
Length (PRODUCTLENGTH)

I am unable to explain it any better than Ive done at the top, Im going to be writing different descriptions for different products but all of them will have (PRODUCTWIDTH) and (PRODUCTLENGTH) where I want it to take the width and length from the title. So if the titles "Safety Security Shatterproof Window Film 50cm x 1m" Id have these listed in column D. In column H Id have the description. Id then need a formula to change the (PRODUCTWIDTH) to say 50cm and (PRODUCTLENGTH) to say 3m. Ive got a number of products which is why I was looking to do it this way rether than by hand. The descriptions will cvhange but they will still have the (PRODUCTWIDTH) and (PRODUCTLENGTH) in and all the titles will have xcm and xm in

Ive used this formula in the past with help from Donkeyote - =SUBSTITUTE(IF(RIGHT($D2,8)="Rear Kit",Sheet3!$A$1,Sheet2!$A$1),"NAMEOFCAR",Sheet4!$A2) for a different project. I thought something like this would work but instead of substituting text from another sheet it would substitute a searched result from column D.

And the search would specify that if the text in column D says 50cm then (PRODUCTWIDTH) is 50cm, if column D says 61cm then (PRODUCTWIDTH) is 61cm, column D says 76cm then (PRODUCTWIDTH) is 76cm, column D says 91cm then (PRODUCTWIDTH) is 91cm, column D says 100cm then (PRODUCTWIDTH) is 100cm, if column D says 117cm then (PRODUCTWIDTH) is 117cm, column D says 122cm then (PRODUCTWIDTH) is 122cm, column D says 152cm then (PRODUCTWIDTH) is 152cm

Then for the length if column D has the text 1m then (PRODUCTLENGTH) is 1m, Then for the length if column D has the text 2m then (PRODUCTLENGTH) is 2m, Then for the length if column D has the text 3m then (PRODUCTLENGTH) is 3m, Then for the length if column D has the text 4m then (PRODUCTLENGTH) is 4m all the way up to 30m in 1 m increments.