title: Wrapping IF ISERROR around INDEX function
body: <p>I have a problem with a dynamic list in Excel 2003 where some cells that I want to be empty are returning <code>#NUM!</code>. I have tried manipulating the following code, but to no avail:  </p>
  
  <blockquote>
    <p>=IF(ISERROR(INDEX(venue_name, SMALL(IF(($A$10=date_ns)*(COUNTIF($A$13:A29,venue_name)=0), ROW(date_ns)-MIN(ROW(date_ns))+1, ""), 1)))  </p>
  </blockquote>
  
  <p>I know its something to do with syntax/parentheses but have exhausted myself trying different combinations. Without the <code>IF(ISERROR(</code> and the closing bracket, the code runs absolutely fine.</p>