| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Replacing #N/A with a '0' (zero)
Hi all,
I'm using a Vlookup to pull figures over from another sheet. Is there a way that when there isn't any data to pull across, instead of displaying #N/A it could display a zero? Thanks in advance... Neil |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| replacing #N/A with 0 | Excel Discussion (Misc queries) | |||
| Replacing characters | Excel Worksheet Functions | |||
| replacing data | Excel Discussion (Misc queries) | |||
| Replacing text in Excel files on disk? | Excel Discussion (Misc queries) | |||
| Filtering and replacing values through a macro | Excel Worksheet Functions | |||
Threaded Mode
