title: Combining a vlookup with string of text
body: <p>Can anyone pleaes explain where the syntax is failing for the following formula? </p>
  
  <pre><code>Selection.FormulaLocal = "=concatenate(vlookup(" &amp; i &amp; ", _
  inputs!A5:B43,2,false), " some words")""
  </code></pre>
  
  <p>The formula works fine if I want to simply use the <code>vlookup</code>, but when I try to add text I am coming across syntax errors. Is there a better way to do this without using <code>FormulaLocal</code>. Can I combine a vlookup with text any other way?</p>
  
  <p>Thanks!</p>