Excel ISNA Function
ISNA function helps to get rid of #N/A code error
Using ISNA function we can tell Excel to leave the cell blank or to display any desired text like "not found" instead of displaying #N/A code error. See how the function is used in the example:
The function is:
The above function has three parts:
First part: =if(isna(vlookup(E4,list1,2,false)), It means if the function don't find the value of cell E4 in List1 then display second part.
Second part: "", It means leave the cell blank. You can write text between quotation marks that you want to display instead of a blank cell.
Third part: vlookup(E4,list1,2,false)) It means if the function finds the value then perform vlookup as usual. See the images given below: