Remove #N/A Excel & Vlookup #n/a error

In 2 steps – How to remove #n/a in Excel? – Fixing Vlookup #n/a

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.