Mynda Posted February 15, 2011 Report Share Posted February 15, 2011 Before the introduction of the IFERROR formula in Excel 2007, if you wanted to hide errors displayed by some formulas you had to employ a combination of IF and the ISNA formulas, which resulted in Excel having to do the calculation twice. Once to establish whether the result was an error, and again if the result wasn’t an error. In big spreadsheets this meant significant perfomance issues. Thankfully Excel 2007 introduced the IFERROR formula which puts an end to these messy workarounds. The IFERROR formula can be used as a ‘wrapper’ to hide many different errors; #DIV/0!, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!, and one of the most common being VLOOKUP’s #N/A error. In this tutorial we’re going to look at using the IFERROR to solve VLOOKUP’s #N/A error. We’ll cover why we might want Excel to hide this error, and how we can tell Excel to display something more elegant in its place. More about Excel tutorials on the link provided. Link to comment Share on other sites More sharing options...
monkeyseemonkeydo Posted February 15, 2011 Report Share Posted February 15, 2011 Excel spam? Really? Reported. Link to comment Share on other sites More sharing options...
quick_spider Posted February 15, 2011 Report Share Posted February 15, 2011 Before the introduction of the IFERROR formula in Excel 2007, if you wanted to hide errors displayed by some formulas you had to employ a combination of IF and the ISNA formulas, which resulted in Excel having to do the calculation twice. Once to establish whether the result was an error, and again if the result wasn’t an error. In big spreadsheets this meant significant perfomance issues. Thankfully Excel 2007 introduced the IFERROR formula which puts an end to these messy workarounds. The IFERROR formula can be used as a ‘wrapper’ to hide many different errors; #DIV/0!, #NAME?, #NULL!, #NUM!, #REF!, #VALUE!, and one of the most common being VLOOKUP’s #N/A error. In this tutorial we’re going to look at using the IFERROR to solve VLOOKUP’s #N/A error. We’ll cover why we might want Excel to hide this error, and how we can tell Excel to display something more elegant in its place. More about Excel tutorials on the link provided. Don't be a douche. Pre Excel 2007, you just use the ISERROR operator. If your PC is slow, get a better one! 1 Link to comment Share on other sites More sharing options...
Recommended Posts