i-nth - Excel IFERROR function with formula examples

Excel IFERROR function with formula examples

30 September 2017

The tutorial shows how to use IFERROR in Excel to catch errors and replace them with a blank cell, another value or a custom message.

You will learn how to use the IFERROR function with VLOOKUP and INDEX MATCH, and how it compares to IF ISERROR and IFNA.

Full article: Excel IFERROR function with formula examples

Essential reading

The reification of an incorrect and inappropriate spreadsheet model

Once information is loaded into a spreadsheet, it acquires properties that it may not deserve – a process called reification.

Latest articles

Consulting

We can help you make better spreadsheets:

Reviewing your spreadsheets for errors.
Advice about improving your spreadsheets.
Training in spreadsheet good practice.