title: If value not found, display "--"
body: <p>I have a sheet (LC AVERAGE) that has a list of names and a column of values. I am looking to display the values on an OVERVIEW sheet that I have, but there are more names on the OVERVIEW sheet than on the LC AVERAGE sheet. I tried <code>IFERROR</code> and <code>IF</code>, but am getting <code>0</code> in cells where the name doesn't match, which is affecting other formulas on the OVERVIEW page. </p>
  
  <pre><code>=IFERROR((SUMIF('LC AVERAGE'!$A:$A,OVERVIEW!$B8,'LC AVERAGE'!$Z:$Z)),"--")
  </code></pre>
  
  <p>I basically need it to display the value in LC AVERAGE'!$Z:$Z on the overview page if the names in 'LC AVERAGE'!$A:$A match the names on OVERVIEW!$B8 (B column), and if the name doesn't exist, display <code>--</code>.</p>
  
  <p>I think the issue is that it isn't counted as an error in Excel if the name simply isn't there, but I've searched and I can't get this to work.  </p>
  
  <p>Any thoughts?</p>