Blank Cell instead of #N/A

[learning_codes]

Hi,

=VLOOKUP(A40,'WITH GOOD'!$A$2:$D$1000,2)

Is there a way to show "blank cell" instead of #N/A in the cell
"A40"?

Thanks

 

[Max]

Try:

=IF(ISNA(VLOOKUP(A40,'WITH GOOD'!$A$2:$D$1000,2)),"",VLOOKUP(A40,'WITH
GOOD'!$A$2:$D$1000,2))

 

[Traveller]

If your concern is how your spreadsheet prints and not with how it looks on
the monitor, go to Page Setup, and on the "Sheet" tab about two-thirds of the
way down choose, "Cell errors as: <blank>".

 

[pleclerc]

Hi,

=VLOOKUP(A40,'WITH GOOD'!$A$2:$D$1000,2)

Is there a way to show "blank cell" instead of #N/A in the cell
"A40"?

Thanks

You can use ISNA or the ISERROR that covers all errors.

See an easy way to do this in chapter 10 of

http://www.excel-vba.com/excel-10-iserror.htm