VLOOKUP #N/A result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When VLOOKUP fails to find a match the result #N/A is shown. Is there a way
to have another result displayed such as NOT FOUND or NO?

Thanks,
Joe M
 
You have to test the result of the VLOOKUP first with the ISNA function, then
decide what to do. Example:
=IF(ISNA(VLOOKUP(6,E14:F18,2,0)), "Not Found", VLOOKUP(6,E14:F18,2,0))
 
Use a formula like:

=IF(ISERROR(VLOOKUP(...)),"NOT FOUND",VLOOKUP(...))

In Excel 2007, you can use the new IFERROR function.

=IFERROR(VLOOKUP(...),"NOT FOUND")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Back
Top