add an extra argument on the end of your vlookup. ie
=(vlookupD10,A2:C10,2,False)

the False on the end makes excel search for an exact match only




"Kim Greenlaw" <Kim wrote in message
...
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.