I have a VLOOKUP that works fine when there is match, but when there isnt it shows a value of #N/A in the cell. Is there any way to not show the ugly #N/A value?
My lookup table is sorted, and I am matching on email address.

See screen shot attached.

Also when there is a match, if the lookup cell has a blank in it, for some reason it is returning a 0.

Click image for larger version. 

Name:	2014-03-19_17-34-56.jpg 
Views:	26 
Size:	60.8 KB 
ID:	2154