Replace #N/A Or Zero In VLOOKUP With Blank Or Specified Text In Excel

Have you encountered a problem that it returns the #N/A error value or zero when you applying VLOOKUP function in Excel? Here, the Replace 0 or #N/A with Blank or a Specified Value utility of Kutools for Excel can help you to replace the zero or #N/A error with empty or a specified value by creating a formula in Excel.