How to Use IFERROR with VLOOKUP in Google Sheets

Last Updated on October 31, 2023 by Jake Sheridan

In this tutorial, you will learn how to use the IFERROR function with VLOOKUP in Google Sheets.

How to Use IFERROR with VLOOKUP in Google Sheets

VLOOKUP is a powerful Google Sheets function that can help you quickly extract information from large datasets. But if your function does not return any matches, you will likely see a #N/A! error.

Fortunately, there is a way to avoid these errors and make your VLOOKUPs more reliable. By combining the IFERROR and VLOOKUP functions, you can create a dynamic formula that won’t display an error if it can’t find a match.

In this guide, we will show you how to use IFERROR with VLOOKUP in Google Sheets.

How to Handle #N/A Error for VLOOKUP Function in Google Sheets

Here’s our step-by-step guide on how to handle #N/A error for VLOOKUP functions in Google Sheets.

Step 1

First, select an empty cell where we’’ll place our formula.

Step 2

Next, type the IFERROR function. For now, we’ll leave the first argument blank. In the second argument, we’ll add our custom text. This text will display when an error is encountered.

Step 3

Next, we’ll set up our VLOOKUP function in the first argument of the IFERROR function.

In this example, we’ll try to output the last name given an employee ID.

Step 4

We can modify the formula by adding absolute references. This will enable us to use the AutoFill tool to look up other fields.

Summary

This guide should be everything you need to learn how to use iferror with vlookup in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.