You can see across forums that the way to trap the #N/A error in VLOOKUP Formulas is this way:
=IF(ISERROR(VLOOKUP(A2,$H$18:$I$21,2,FALSE)), "Not found",VLOOKUP(A2,$H$18:$I$21,2,FALSE))
This Formula calls VLOOKUP twice, this means double processing.
Avoid losing time when you work with intensive computing spreadsheets. Use IFERROR instead…
Embed the VLOOKUP Formula into an IFERROR function. The syntax is IFERROR(value,value_if_error). The Formula is done:
=IFERROR(VLOOKUP(A2,$H$18:$I$21,2,FALSE),"Not Found")
.
