How to remove the #N/A error from Vlookup and replace it with a friendly message or a blank cell. Fix the Vlookup Error in Excel 2007, 2010, 2013, and Later Fix the Vlookup Error in Excel 2003 The Problem You get the #N/A error when Vlookup can't find any data or when you haven't entered a value for the lookup_value argument. The Vlookup functi ...
Added: Sep 30, 2015