Removing #N/A

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
You can select to not print any errors.

Set your print area, then
Goto File>Page setup>Sheet tab>Cell errors as>Blank>OK
 
I tried using the list for mail merge. It does not print the #N/A s. Problem
solved, many thanks.
 
Back
Top