How to replace #N/A in Excel with 0 or blank values using formula. Usually a formula like Vlookup returns such errors & this Excel function can handle this.
2 Methods To – Remove #N/A Error in Excel – Vlookup
2 Ways to remove #N/A Excel error in VLOOKUP, Worksheet or VBA Macro code. Fix Vlookup #n/a & Excel #n/a common errors formula. Hide n/a Excel Error.