I have a simple VBA sub:

sub test
Cells(2, 3).FormulaR1C1 = "=LOOKUP(3;R1C2:R5C2;R1C1:R5C1)"
end sub

Result is error ('Run-time error '1004': Application-defined or object
defined error'). Is this Excel-bug or am I missing something?