FormulaCraft

IFERROR

IFERROR wraps a formula and replaces any error (#N/A, #DIV/0!, #REF!) with a value you choose.

Excel
=IFERROR(VLOOKUP(D2, A:B, 2, FALSE), "Not found")
Google Sheets
=IFERROR(VLOOKUP(D2, A:B, 2, FALSE), "Not found")

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Runs server-side · free · no signup

How it works

  1. 1The VLOOKUP runs first.
  2. 2If it errors, "Not found" is shown instead of the error code.

Need a version for your data?

Try: “Do a VLOOKUP for D2 but show Not found instead of an error”

Related

IFIFSSWITCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: