i am trying to update the data but it is not updating instead showing the 2015materials

i am trying to update the data(from the TOOL-OUTPUT) but it is not updating instead showing the 2015materials in some other columns

in settings i have listed attribute name9 and attribute value9 from sheet3 to TOOL-PUT i converted them to decimal now i am trying to update that values of (REPLACE VALUE column) to the sheet3(attribute name9 and attribute value9)
whnevere i run macro it shows #value

Sub UpdateSheet3()
Dim LR As Long

LR = Sheets("Sheet3").Cells(Rows.Count, "A").End(xlUp).Row
With Range("C2:C" & LR)
    .Copy Range("D2")
    .FormulaR1C1 = "=TEXT(LEFT(RC[1],SEARCH(""/"",RC[1])-1)/RIGHT(SUBSTITUTE(RC[1], "" IN"", """"),LEN(SUBSTITUTE(RC[1], "" IN"", """"))-SEARCH(""/"",SUBSTITUTE(RC[1], "" IN"", """"))), "".0###"") & "" in"""
    .Value = .Value
    .Offset(, 1).ClearContents
End With

End Sub

i have attched my excel sheet