title: Nested Concat function within Vlookup not working, Cant seem to find a syntax error
body: <p><a href="https://i.stack.imgur.com/iZRF5.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iZRF5.png" alt="data tab"></a></p>
  
  <p>Hi,</p>
  
  <p>I am trying to concatenate a certain filepath in order to change a subpath and part of the filename. </p>
  
  <p>This is the function I am trying to put into cell D3 </p>
  
  <pre><code> =IFERROR(VLOOKUP($A3,CONCATENATE("'G:\Financial\Facility Work Papers and 
   Financials\1. Operating Entities\Arbors Major Hospital\2. 
   Financials\2018\",BB1,"\[Arbors"," ",BB2," ","2018.xls]Trial 
   Balance'")!$A$30:$H$100,8,FALSE),0)
  </code></pre>
  
  <p>This is the actual filepath on my machine: G:\Financial\Facility Work Papers and Financials\1. Operating Entities\Arbors Major Hospital\2. Financials\2018\4. Apr\Arbors April 2018.xls</p>
  
  <p>Assuming I have text in BB1 and BB2, 4. Apr and April respectively.</p>
  
  <p><a href="https://i.stack.imgur.com/RVa8o.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RVa8o.png" alt="enter image description here"></a></p>