I have a formula that will be implemented into a cell and copied down the column which works for the other types of pricing rules, but this one in particular doesn't seem to be working. As far as I can tell, it is the Cost Multiplier part. Do I need to declare the input box values as anything? Am I putting the Cost Multiplier into the formula wrong? Any help would be greatly appreciated. Thank you
CostMultiplier = InputBox("Cost *", "Cost Multiplier")
Sheets("Vendor Pricing Rules").Cells(2, LCVPR1).Formula = _
"=IF('Input Values'!$L2=$" & Split(Sheets("Vendor Pricing Rules").Cells(2, LCVPR1).Address, "$")(1) & "$1, IF('Input Values'!$J2="""", """", IF('Input Values'!$G2=""SH"", INDEX('$H:$H, MATCH(ROUND('Input Values'!$J2 * " & CostMultiplier & ", 0), $F:$F, 0)), INDEX($G:$G, MATCH(ROUND('Input Values'!$J2 * " & CostMultiplier & ", 0), $F:$F, 0)))), """")"
Admin note: Please put code directly into your post instead of having us download a text file to see it. --6SJ
Bookmarks