Google Sheets reference

IFERROR in Google Sheets

Works in Google Sheets1 worked example

Worked examples (1)

These formulas work in Google Sheets with identical syntax.

Data Cleaningbeginner

=IFERROR(VLOOKUP(A2,$F$2:$G$20,2,FALSE),"-")

Also in Excel

See the full IFERROR reference for Excel — including all worked examples, common errors, and FAQ.