title: Hyperlinks with VLookup - Returns Error - Cannot Open Specified File
body: <p><strong>The problem is:</strong> I have named ranges of cells in <code>sheet3</code>. In <code>sheet2</code> I have created hyperlinks using range names so once you click in any of the links it takes you direct to the related range in <code>sheet3</code>.</p>
  <p>In <code>sheet1</code> I have a table in which  column <code>K</code> is a droplist, in column <code>L</code> I entered this formula:</p>
  <pre><code>=HYPERLINK(VLOOKUP(K3,Sheet2!B48:C92,2,0))
  </code></pre>
  <p>which return the hyperlink matching to the selected value in column <code>K</code> the result returned is exactly the hyperlink in the <em>sheet2</em> but whenever I click any of these hyperlink results an error message pop up saying: <strong>Cannot open the specified file</strong>.</p>
  <p>Even all the links in <code>Sheet2</code> is working fine and it take me direct to the linked range in <code>Sheet3</code>.</p>
  <p>Do I need to insert a macro code to make the Vlookup-Hyperlinks results working and take me to the targeted range in <code>Sheet3</code> and whats the that code?</p>