It is very common for Excel users to observe the #N/A error in large spreadsheets containing VlOOKUPs. In this tutorial I will demonstrate a simple approach to replace the #N/As with blank cells.
Consider the VLOOKUP Below.
As you could observe, #N/A has been returned wherever a value in the lookup list does not exist in the reference array.
The generic formula below is the solution to this problem
=IF(ISNA(VLOOKUP()), ”” ,VLOOKUP())
The screen shot below depicts the result of the formula above when I insert the VLOOKUP statement within the arguments of the IF statement.