How to Replace #N/A or Zero in Vlookup with Blank or Specified Text in Excel?
Tags: kutoolsexceltutorial, replacenaorzeroinwit, kutools
Published: 2021-11-12 09:18:17

---
title: How to Replace #N/A or Zero in Vlookup with Blank or Specified Text in Excel?
published: true
date: 2021-11-08 10:29:00 UTC
tags: KutoolsExcelTutorial,ReplaceNAorZeroinwit,Kutools
canonical_url: https://geekexcel.com/how-to-replace-n-a-or-zero-in-vlookup-with-blank-or-specified-text-in-excel/
---

## Replace #N/A or Zero in Vlookup with Blank or Specified Text in Excel 365:

This article will learn how to  **Replace #N/A or Zero in VLOOKUP with Blank or Specified Text in Excel**.

**Note:** [Kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has many built-in features. They are beneficial to all users around the world. With the help of Kutools functions, you can solve any problem quickly and easily.

## Steps to Replace #N/A or Zero in VLOOKUP with Blank or Specified Text in Excel:

Here are the instructions to replace #N/A or zero in vlookup with blank or specified text in Excel 365.

- We have shown an example data table to know how to solve this type of error in Excel.

![](https://geekexcel.com/wp-content/uploads/2020/07/gh13.png)

- On the  **Kutools**  tab, Select the  **Super LOOKUP**  option. It will open the menu.
- **Choose Replace 0 or #N/A error with Blank or a Specified value**  option from the menu.

![](https://geekexcel.com/wp-content/uploads/2020/07/gh14.png)

- It will open the  **Replace 0 or #N/A error with Blank or a Specified value dialog box**.
- Give input by selecting cells to the  **Lookup Values**  and  **Output Range**  boxes.
- **Check Replace 0 or #N/A error with empty ** option.
- In the  **Data Range**  option, choose the Table of data as input.
- **Key Column**  – Select the cells which have the lookup value.
- **Return Column**  – Select the cells where you want to place the output.

![](https://geekexcel.com/wp-content/uploads/2020/07/gh15.png)

- Hit the **Ok** button. It will show all matched values in the result cells. If there is no match, it returns blank.

![](https://geekexcel.com/wp-content/uploads/2020/07/gh16.png)

### Replace zero or #N/A error with the specified value:

- It is similar to replacing zero or #N/A error with blank in Excel. So you have to do the same as the above.
- It would help if you filled the  **Lookup values** ,  **output range**  boxes.
- Choose to  **Replace 0 or #N/A error value with a specified value ** option, and you need to fill the below  **text**  box.
- From the  **Key Column**  drop-down list, select the column of the lookup value.
- In the  **Return Column**  box, give input by selecting the result cell.

![](https://geekexcel.com/wp-content/uploads/2020/07/gh17.png)

- Hit the **Ok** button. It will return the matched values in the selected cells. If there is no matched value, it returns the specified text.

![](https://geekexcel.com/wp-content/uploads/2020/07/gh18.png)

### Note:

If you want to know how it works, Click the  **Example**  button in the  **Replace 0 or #N/A**   **error with blank or specified value**   **dialog box**  to see how to use this.

![](https://geekexcel.com/wp-content/uploads/2020/07/gh19.png)

## Closure:

In the above article, you can understand how to **Replace #N/A or Zero in VLOOKUP with Blank**  **or Specified Text in Excel using Kutools**. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!