Thread
:
Replacing #N/A with a '0' (zero)
View Single Post
#
1
neilcarden
Junior Member
Posts: 26
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
Reply With Quote
neilcarden
View Public Profile
Send a private message to neilcarden
Find all posts by neilcarden