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)

"Joe M." wrote in message
...
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