vba - Expected end of Statement Error on Simple Formula Insert

Question

###.value = "=LOOKUP(LEFT(W2),{"C","A","B"},{"Pick Up","Collect","Prepaid"})"

I want VBA to do this simple formula but getting "Expected: end of Statement" error. It seems that I need to define something as VBA doesn't recognize character "{}" the brackets.

Answer 1

Assuming that ### actually symbolizes a cell object (otherwise you would get a compile error):

###.Value = "=LOOKUP(LEFT(W2),{""C"",""A"",""B""},{""Pick Up"",""Collect"",""Prepaid""})"

Also, I thought that you would have to change .Value to .Formula, but I tested and both ways work.