MrExcel Publishing
Your One Stop for Excel Tips & Solutions

#N/B


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

Eric


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

Eric,

Is it the Dutch version that you use?

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

=IF(ISNA(VLOOKUP(lookup-value,lookup-table,column-number,match-type)),"",VLOOKUP(lookup-value,lookup-table,column-number,match-type))

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

Aladin

=========

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).