title: How to create hyperlinks that link to files in different folder locations?
body: <p>I have a column in excel with the names of different invoices on my computer and I need to create a hyperlink for each invoice name. I tried to press CTRL+K and manually create a hyperlink for each invoice at the beginning, but that was just too much work because I have hundreds of invoices. </p>
  
  <p>Right now, I am using this formula:</p>
  
  <pre><code>=HYPERLINK("C:\Users\Jimmy\Documents\Excel Formula Testing\2015\January" &amp; B2 &amp; ".xlsx", B2)
  </code></pre>
  
  <p>and it is working fine. However, not every invoice is in this folder so, I need a formula that looks up the file from the external folder.</p>
  
  <p>        <a href="https://i.stack.imgur.com/9f6lb.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9f6lb.png" alt="The excel sheet looks something like this"></a></p>