title: Return blank if #VALUE is returned
body: <p>I've setup a formula that combines numbers from multiple worksheets and then compares it against another number from worksheet.</p>
  
  <p>I am using the <code>INDIRECT</code> function to reference the sheets as well as <code>COLUMN</code> and <code>ROW</code> to adjust the numbers to the corresponding coordinates when I drag it across.</p>
  
  <p>However, some of the figures don't always exist in the worksheets so a <code>#VALUE</code> error is returned. How Can I change it so a blank cell is shown if this happens?</p>
  
  <p>My Current formula: <code>=INDIRECT("'"&amp;$C$11&amp;"'!R"&amp;ROW(E29)&amp;"C"&amp;COLUMN(E29),FALSE)-SUM(INDIRECT("'"&amp;$C$11&amp;"'!R"&amp;ROW(C29)&amp;"C"&amp;COLUMN(C29),FALSE),INDIRECT("'"&amp;$C$13&amp;"'!R"&amp;ROW(E29)&amp;"C"&amp;COLUMN(E29),FALSE))</code></p>