Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

#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

Check out our Excel Resources

Re: #N/B

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

=========

Re: #N/B

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.