title: How do I replace all error values in a column
body: <p>I have a column which is populated using Index and Match functions and it results in a N/A value when the value is not found. I want to be able to replace all such error values from the column by a special value. I want to do this in VBA code. Any help?</p>
  
  <p>I do not want to rewrite the function with an IF logic. </p>