Microsoft Office Tutorials and References
In Depth Information
Looking Up an Exact Value
Figure 120-2: This lookup table requires an exact match.
If you prefer to see something other than #N/A when the employee number isn’t found, you can
use the IFERROR function to test for the #N/A result (using the ISNA function) and substitute a
different string. The following formula displays the text “Not Found” rather than #N/A:
=IFERROR(VLOOKUP(B2,D1:E11,2,FALSE),”Not Found”)
The IFERROR function was introduced in Excel 2007, so if your workbook must be compatible
with earlier versions, use this formula:
=IF(ISERROR(VLOOKUP(B2,D1:E11,2,FALSE)),”Not Found”,
VLOOKUP(B2,D1:E11,2,FALSE))
 
Search JabSto ::




Custom Search