Home › Guides › How to Use IFERROR in Excel
Error Correction

How to Use IFERROR in Excel

Last updated: 2026-09-06

⚡ Quick Answer

IFERROR catches formula calculation errors and outputs an alternative user-defined text or numeric result.

=IFERROR(VLOOKUP(A2, Sheet2!A:B, 2, FALSE), "Not Found")

📊 Visual Demo

Book1 - Excel
HOME · INSERT · FORMULAS · DATA
fx =IFERROR(VLOOKUP(A2, Sheet2!A:B, 2, FALSE), "Not Found")
ABCDE
11Missing ID#N/A Error=IFERROR(VLOOKUP(...), "Missing")Missing
22Valid ID$450.00No Error Triggered$450.00
33Zero Div#DIV/0!=IFERROR(A2/B2, 0)0

🧠 Deep Dive

IFERROR catches formula calculation errors and outputs an alternative user-defined text or numeric result.

Key Insights

  • Every error code tells you the failure class.
  • IFERROR should wrap the smallest possible expression.

Common Mistakes

  • Blanket-wrapping everything in IFERROR.
  • Deleting rows that other formulas reference.

Pro Tips

  • Use Go To Special > Errors.
  • Fix errors from top-left outward.

FAQ

What does this formula do in plain English?

IFERROR catches formula calculation errors and outputs an alternative user-defined text or numeric result.

Why is my formula not working?

Blanket-wrapping everything in IFERROR.

Does this work in Google Sheets?

Yes, this syntax is fully compatible with Google Sheets.

What is the most common mistake?

Deleting rows that other formulas reference.

Related Guides

How to Fix the #SPILL! Error in ExcelHow to Fix the #VALUE! ErrorHow to Fix the #REF! ErrorHow to Fix the #N/A ErrorExcel Error Hub

Need Complete Playbooks?

Download our verified manuals covering ERP Cleanup and Modeling.

Explore Playbook Series (From ₹199)