| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing patterns without removing gridlines | Excel Discussion (Misc queries) | |||
| Removing Blanks | Excel Worksheet Functions | |||
| Removing a word | Excel Worksheet Functions | |||
| Removing Hyperlink | Excel Discussion (Misc queries) | |||
| Removing the +4 from zip+4 | Excel Discussion (Misc queries) | |||
Linear Mode
