How to Use IFERROR with VLOOKUP in Google Sheets


You can use the following formula with IFERROR and VLOOKUP in Google Sheets to return a value other than #N/A when the VLOOKUP function does not find a particular value in a range:

=IFERROR(VLOOKUP("string",A2:B11,2,FALSE),"Does Not Exist")

This particular formula looks for “string” in the range A2:B11 and attempts to return the corresponding value in the second column of this range.

If it does not find “string” then it simply returns “Does Not Exist” instead of a #N/A value.

The following example shows how to use this formula in practice.

Example: Use IFERROR with VLOOKUP in Google Sheets

Suppose we have the following dataset that shows the number of points scored by various basketball teams:

Suppose we use the following VLOOKUP formula to find the number of points associated with the “Raptors” team:

=VLOOKUP("Raptors",A2:B11,2,FALSE)

The following screenshot shows how to use this formula:

This formula returns a value of #N/A because the “Raptors” do not exist in the Team column.

However, we can use the following IFERROR function with the VLOOKUP function to return a value of “Does Not Exist” instead of #N/A:

=IFERROR(VLOOKUP("Raptors",A2:B11,2,FALSE),"Does Not Exist")

The following screenshot shows how to use this formula:

IFERROR VLOOKUP in Google Sheets

Since the “Raptors” do not exist in the Team column, the formula returns a value of “Does Not Exist” instead of a #N/A value.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

How to Use a Case Sensitive VLOOKUP in Google Sheets
How to Use a Case Sensitive VLOOKUP in Google Sheets

Leave a Reply

Your email address will not be published.