Removing #N/A
 

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?

Removing #N/A
 

You can select to not print any errors.

Set your print area, then
Goto FilePage setupSheet tabCell errors asBlankOK

--
Biff
Microsoft Excel MVP


"nibble" wrote in message
...
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?

Removing #N/A
 

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

Nibble

"T. Valko" wrote:

You can select to not print any errors.

Set your print area, then
Goto FilePage setupSheet tabCell errors asBlankOK

--
Biff
Microsoft Excel MVP


"nibble" wrote in message
...
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?

Removing #N/A
 

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


"nibble" wrote:

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

Nibble

"T. Valko" wrote:

You can select to not print any errors.

Set your print area, then
Goto FilePage setupSheet tabCell errors asBlankOK

--
Biff
Microsoft Excel MVP


"nibble" wrote in message
...
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?

Removing #N/A
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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


"nibble" wrote:

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

Nibble

"T. Valko" wrote:

You can select to not print any errors.

Set your print area, then
Goto FilePage setupSheet tabCell errors asBlankOK

--
Biff
Microsoft Excel MVP


"nibble" wrote in message
...
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?