Calc's advanced pattern matching is simple and direct.
How-To Geek on MSN
Stop using IFERROR and ISERROR in Excel: Use IFNA instead
Don't fall into the trap of masking structural errors in your spreadsheet.
Some results have been hidden because they may be inaccessible to you
Show inaccessible results