If you have a lookup value in cell A1 and lookup values in a range named table, and you want a cell to be blank if no lookup is found, you can use: If you want to return the message “Not found” when no match is found, use:
IFNA option
In Excel 2013, the IFNA function is available to trap and handle #N/A errors specifically. The usage syntax is the same as with IFERROR:
Older versions of Excel
In earlier versions of Excel that lack the IFERROR function, you’ll need to repeat the VLOOKUP inside an IF function that catches an error with ISNA or ISERROR. For example:
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
