The standard was is:
=if(isna(vlookup(....)),"",vlookup(.....))

If you have XL2007, you can use:
=iferror(vlookup(....),"")

Regards,
Fred.

"tbrownusa" wrote in message
...
Is there a way to hide the "#N/A" result in a VLOOKUP calculation when the
result is not possible?