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 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.

• 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.

• 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.

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

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.

• 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.

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.

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. Keep Learning!!