title: VBA to fill in VLOOKUP formula in Cell: Shows Error, What's wrong?
body: <pre><code>Sub ()
  
  Cells(2, ThisWorkbook.Sheets(&quot;Sheet1&quot;).UsedRange.Columns.Count + 5).Formula = &quot;=VLOOKUP(A2,'Sheet2'!$B$3:$BB$41,MATCH(RIGHT(R[-1]C,2),'Sheet2'!$B$3:$AZ$3,0),FALSE)&quot;
  
  End Sub()
  </code></pre>