Removing #N/A

[Guest]

Hi
I am using VLOOKUP to return data associated with the source data, which is
in cells. Some of the source cells are actually empty, and return a #N/A. I
wish to print the returned data, with a blank where the #N/A s currently are.
Is this possible?

 

[T. Valko]

You can select to not print any errors.

Set your print area, then
Goto File>Page setup>Sheet tab>Cell errors as>Blank>OK

 

[Guest]

Thanks Biff
Does this work if I use the data for mail merge?

Nibble

 

[Guest]

I tried using the list for mail merge. It does not print the #N/A s. Problem
solved, many thanks.

 

[T. Valko]

You're welcome. Thanks for the feedback!