vlookup n/a code example

Example 1: VLOOKUP CHECK #N/A

=IFERROR(VLOOKUP(A1,table,2,FALSE),"Not found")
=IFNA(VLOOKUP(A1,table,2,FALSE),"Not found")

Example 2: VLOOKUP CHECK #N/A

=IFERROR(VLOOKUP(A1,table,2,FALSE),"")

Example 3: VLOOKUP CHECK #N/A

=IFERROR(VLOOKUP(A1,table,2,FALSE),"Not found")

Example 4: VLOOKUP CHECK #N/A

=IF(ISNA(VLOOKUP(A1,table,2,FALSE)),"",VLOOKUP(A1,table,2,FALSE))