Have ben trying to add some code to my spreadsheet, and not getting anywhere fast.
Currently the formula I'm using is...
=IF(E6="AR Coating Type","",(LOOKUP($E6,'Calc Sheet'!$O$2:$O$21,'Calc Sheet'!$P$2:$P$21)))
Tried to convert this to code and came up with this..
If Target.Column = 5 Then
With Target.Offset(0, 1)
.FormulaR1C1 = _
"=IF(RC5="AR Coating Type","""","LOOKUP(RC5,'Calc Sheet'!R2C15:R21C15,'Calc Sheet'!R2C16:R21C160))"
.Value = .Value
End With
But its not working and keeps generating a Syntax Error.
Any ideas which bit I've got wrong.
Thanks,
Gavin
Bookmarks