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