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.
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.