=if(iserror(vlookup(...)),"",vlookup(...))

if you're using xl2007, you may want to try:
=iferror(vlookup(...),"")



FP Novice wrote:

How do I show cells as empty (that actually house VLOOKUP formulas) instead
of the default #N/A?

Todd

--

Dave Peterson