title: Excel IFERROR returns #NAME?
body: <p>I am using INDEX/MATCH to look up values for cells in a column against an external workbook. This is working fine, but when a value is not returned, the cell gets #N/A instead. I need to trap this error and return the value UNKNOWN. Here’s my formula:-</p>
  
  <pre><code>=IFERROR(INDEX(Wards,MATCH(B28,Postcodes,0)),”UNKNOWN”)
  </code></pre>
  
  <p>Both Wards and Postcodes are named ranges in the external workbook (ranges are named locally).</p>
  
  <p>However, IFERROR is returning #NAME?</p>
  
  <p>No matter what I try I cannot get round this. I have tried different strategies like using IFNA, IF/ISERROR, IF/ISNA etc.</p>
  
  <p>I am using Excel 2013.</p>
  
  <p>I have seen a solution in Stack Overflow relating to the same problem where the function is written in VBA, and the reason given is that the error “never makes it past the MATCH function”, and hence is not trapped by IFERROR. I haven’t been able to adapt the solution to this to solve my problem.</p>