MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Eric Ooft on July 02, 2001 3:27 AM

Greetings !!

Is it possible to dissolve the '#N/B' output when VLOOKUP fails to find something.
I thought of the 'white ink on white paper' effect, but that doesn't work with formulas.

Any suggestions ???

Thanks in advance


Posted by Aladin Akyurek on July 02, 2001 3:45 AM


Is it the Dutch version that you use?

You can suppress #N/B (#N/A) by computing twice as in


If you would like to post your formula (even if in Dutch), I could suggest another way.



Posted by RayH on July 02, 2001 12:13 PM

In conditional formatting, choose Formula Is and use =iserror(cellref) and under formatting make the font the same color as the background
(most cases is white).