Remove #N/A in vlookup result

The Solution to Remove #N/A in vlookup result is

If you only want to return a blank when B2 is blank you can use an additional IF function for that scenario specifically, i.e.


or to return a blank with any error from the VLOOKUP (e.g. including if B2 is populated but that value isn't found by the VLOOKUP) you can use IFERROR function if you have Excel 2007 or later, i.e.


in earlier versions you need to repeat the VLOOKUP, e.g.


~ Answered on 2013-01-07 20:14:30

Most Viewed Questions: