Blank Cell instead of #N/A

  • Thread starter Thread starter learning_codes
  • Start date Start date
L

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
 
Try:

=IF(ISNA(VLOOKUP(A40,'WITH GOOD'!$A$2:$D$1000,2)),"",VLOOKUP(A40,'WITH
GOOD'!$A$2:$D$1000,2))
 
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>".
 
Back
Top