use the false argument:
=VLOOKUP(A14, Sheet4!$A$66:$B$70, 2, FALSE)
if no match, it will return #N/A

"Kim Greenlaw" wrote:

If lookup doesn't find a match in the first column, can I get it to return an
"ERR" or "0", something that would let me know there was no match? Right now
it returns the value in the second column of the closest value.