I'm using some vlookup formulas to verify dates, and I want to get a "0"
response for dates that are not in my lookup list rather than "#n/a".
Any suggestions on a formula?
I tried =if(vlookup(date,A1:A500,1,0)=1,1,0)
However this still giving me a #n/a answer.

Thanks