1004 error when trying to insert formula with "vlookup" : <p>I am new to vba (actually started yesterday) so please excuse my ignorance on details I should include in my question.</p>

<p>I am trying to use a macro to insert a formula containing "vlookup" into a cell in excel. However, if I try to run the macro, I get an error "1004 - application defined or object defined error"</p>

<p>The line that causes the issue:</p>

<pre><code>Worksheets("Berechnungen").Cells(19, 10).Formula = "=VLOOKUP(R3C1;R9C1:R12C1;16;FALSE)"
</code></pre>

<p>I tried different formulas like</p>

<pre><code>Worksheets("Berechnungen").Cells(19, 10).Formula = "=SUM(R3C4:R3C5)"
</code></pre>

<p>that all worked like a charm.</p>

<p>I am using Microsoft Office 365 ProPlus, version 1708 in German language.</p>

<p>Please let me know if you require any additional information!</p>

<p>Thanks for your help!</p>
