Hi Radzmar,That is an excellent representation of what I need to do. However I need to be able to incorporate calculated values depending on the item selected in each field. PipeType: if(pipetype = "110x50 Sq","DPS","DP") // using excel 'if then else' formatUpstand = 110Soffit = if ((this.getFiel...