In this Article

*This tutorial will **demonstrate how to handle VLOOKUP #N/A errors in Excel and Google Sheets.*

## IFNA in VLOOKUP

When you lookup a value with the VLOOKUP Function, if the value is not found, VLOOKUP will return the #N/A error.

1 |
=VLOOKUP(E3,B3:C6,2,FALSE) |

You can add the IFNA Function outside of the VLOOKUP, to do something else if the VLOOKUP results in an IFNA error. In this example, we will output “Not found” if the VLOOKUP results in an #N/A error:

1 |
=IFNA(VLOOKUP(E3,B3:C6,2,FALSE),"Not found") |

Another common use of the IFNA Function is to perform a second VLOOKUP if the first VLOOKUP can not find the value. This may be used if a value could be found on one of two sheets; if the value is not found on the first sheet, lookup the value on the second sheet instead.

1 |
=IFNA(VLOOKUP(E3,B3:C6,2,FALSE),VLOOKUP(E3,'Sheet 02'!B3:C6,2,FALSE)) |

## IF ISNA in VLOOKUP

The IFNA Function was introduced in Excel 2013. Prior to that, you had to use the more complicated IF / ISNA combination:

1 |
=IF(ISNA(VLOOKUP(E3,B3:C6,2,FALSE)),"Not found",VLOOKUP(E3,B3:C6,2,FALSE)) |

The ISNA function checks whether the result of the VLOOKUP formula is an #N/A error and returns True or False accordingly. If it is true (i.e., your lookup value is missing from the lookup array), the IF function will return with a message you specify, otherwise it will give you the result of the VLOOKUP.

## IFERROR – VLOOKUP

As stated above, the IFNA Function tests if the formula outputs only a #N/A error. Instead, the IFERROR Function can be used to check if **ANY** error is returned:

1 |
=IFERROR(VLOOKUP(E3,B3:C6,2,FALSE),"Not found") |

## If ISNA & IFNA in VLOOKUPs – Google Sheets

These formulas work the same in Google Sheets as in Excel.