try
=if(isna(vlookup(...),"",vlookup())

"yrat" wrote in message
...
As a result of a Vlookup formula a cell gives #N/A. The formula and the
data
that it looks up is good. It should give a #N/A. I need the cell instead
of
displaying #N/A to display nothing (blank) without deleting the formula.