title: How can I remove #N/A in a formula string
body: <p>I have</p>
  
  <ul>
  <li>excelfiles with in first colomn the subject nameand in the n-the column a variable i'm interested in from that ID.</li>
  <li>I have several such files with different subject names (but from the same pool)</li>
  <li>Every excelfile is the same test done under a new condition</li>
  <li>for every ID i have figures saved in a map.</li>
  </ul>
  
  <p>I wanted to obtain the following:</p>
  
  <ul>
  <li>making a new file where 
  <ul>
  <li>the first column are all my ID's from my masterpool</li>
  <li>every file/sheet stands for one n variable. Every column is the value of that variable under the condition defined by the column. (so kinda like a switch)</li>
  <li>not every cell has a value, some are empty </li>
  <li>If a cell has a value, I want to make it a hyperlink and link it to a figure</li>
  </ul></li>
  </ul>
  
  <p>Everything worked except for one thing: I can't leave empty cells blank.</p>
  
  <p>Here I have written two formula's in Excel that do what I want to but still give me a #N/A or #NAME if cells are empty</p>
  
  <p>Can anyone give me some pointers?</p>
  
  <pre><code>=if(vlookup($A3;'C:\Users\Gebruiker\Desktop\THE END\Resultaten\[Model btt.xls]0 female'!$A$1:$O$65536;8;false); HYPERLINK(concatenate ("C:\Users\Gebruiker\Desktop\THE END\Figuren\Model btt_ Minimum age 0_ Gender female_ File ";A3;".tif");vlookup($A3;'C:\Users\Gebruiker\Desktop\THE END\Resultaten\[Model btt.xls]0 female'!$A$1:$O$65536;8;false));””)
  
  
  
  =if.error(HYPERLINK(concatenate("C:\Users\Gebruiker\Desktop\THE END\Figuren\Model btt_ Minimum age 0_ Gender female_ File ";A3;".tif");vlookup($A3;'C:\Users\Gebruiker\Desktop\THE END\Resultaten\[Model btt.xls]0 female'!$A$1:$O$65536;8;false));””)
  </code></pre>
  
  <p>Thanks</p>