 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / July 2007Removing #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? You can select to not print any errors. Set your print area, then Goto File>Page setup>Sheet tab>Cell errors as>Blank>OK  SignatureBiff Microsoft Excel MVP > Hi > I am using VLOOKUP to return data associated with the source data, which [quoted text clipped - 4 lines] > are. > Is this possible? Thanks Biff Does this work if I use the data for mail merge? Nibble > You can select to not print any errors. > [quoted text clipped - 9 lines] > > are. > > Is this possible? I tried using the list for mail merge. It does not print the #N/A s. Problem solved, many thanks. > Thanks Biff > Does this work if I use the data for mail merge? [quoted text clipped - 14 lines] > > > are. > > > Is this possible? You're welcome. Thanks for the feedback! SignatureBiff Microsoft Excel MVP >I tried using the list for mail merge. It does not print the #N/A s. >Problem [quoted text clipped - 21 lines] >> > > are. >> > > Is this possible? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.