Excel Formulas to Hide the #N/A Error with VLOOKUP Function!!
Tags: excelformula, excelformulas
Published: 2021-02-15 09:49:46

---
title: Excel Formulas to Hide the #N/A Error with VLOOKUP Function!!
published: true
date: 2021-02-15 06:35:25 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-hide-the-n-a-error-with-vlookup-function/
---

When using the **[VLOOKUP formula](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** in Excel, sometimes you may end up with the **#N/A error**. This happens when your formula cannot find the lookup value. In this tutorial, I will show you different ways to **hide this #N/A error** and get rid of this problem. Let’s see them below!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to VLOOKUP without #N/A error](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Formulas-to-VLOOKUP-without-NA-error.png)](https://geekexcel.com/excel-formulas-to-hide-the-n-a-error-with-vlookup-function/formulas-to-vlookup-without-na-error/#main)<figcaption id="caption-attachment-21877">Formulas to VLOOKUP without #N/A error</figcaption>

## Generic Formula:

- Use the below formula based on **IFERROR** and **VLOOKUP** function to show something meaningful in place of the **#N/A error**.

**=[IFERROR](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)([VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(A1,table,column,[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)),”Message”)**

## Syntax Explanations:

- **IFERROR** – This function will help to return a custom result when a formula generates an error and a standard result when no error is detected. Read more on the **[IFERROR Function](https://geekexcel.com/use-iferror-function-in-microsoft-excel-365-easy-tutorial/)**.
- **VLOOKUP** – In Excel, the **[VLOOKUP function](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)** helps to lookup data in a range or table by row.
- **FALSE** – This function helps to return the logical value FALSE. Read more on the **[FALSE Function](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)**.
- **Table** – It represents the input ranges from your data.
- **Column** – It specifies the column number.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Let’s see the below example to get rid of the **#N/A error** or any other errors while using the VLOOKUP function.

### Example 1:

- First, we will give the input values in **Column B** and **Column C**.

![Input Ranges](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Input-Ranges-10.png)<figcaption id="caption-attachment-21873">Input Ranges</figcaption>

- Here, the normal **VLOOKUP function** creates a **#N/A error**.

![Result for VLOOKUP](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-for-VLOOKUP.png)<figcaption id="caption-attachment-21874">Result for VLOOKUP</figcaption>

- So, apply the above give formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section or any other cells where you want to show the result.
- Press the **“Enter”** key.

![Result of IFERROR](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-of-IFERROR.png)<figcaption id="caption-attachment-21875">Result for IFERROR</figcaption>

- Finally, it will return the result in the selected cell.

### Example 2:

You can also use the **IFNA function** instead of the **IFERROR function** to solve this problem. Just use the below formula.

**=[IFNA](https://geekexcel.com/ifna-function-in-microsoft-excel-365-how-to-use/)([VLOOKUP](https://geekexcel.com/how-to-use-excel-vlookup-function-in-office-365/)(A1,table,column,[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)),”Message”)**

- **[IFNA Function](https://geekexcel.com/ifna-function-in-microsoft-excel-365-how-to-use/)** – It will return a **custom result when a formula generates the #N/A error, and a standard result will be displayed when no error is detected**.

Apply the above-given formula to the formula bar section it will display the result as per the below image.

![Result of ISNA](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2021/02/Result-of-ISNA.png)<figcaption id="caption-attachment-21876">Result of ISNA</figcaption>

## Bottom-Line:

From this tutorial, we have described the simple and useful **formulas to hide the #N/A error in Excel** with **VLOOKUP** along with **IFERROR** and **IFNA** functions. If you have any **doubts,** feel free to share them with us. We will assist you. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Lookup Two Tables with VLOOKUP Function!!](https://geekexcel.com/excel-formulas-lookup-two-tables-with-vlookup-function/)**
- **[Formulas to Replace #N/A or Zero in Vlookup with Blank or Specified Text!!](https://geekexcel.com/formulas-to-replace-n-a-or-zero-in-vlookup-with-blank-or-specified-text/)**