use the final argument of false

=vlookup(value,range,column,false)

Now, if there's now match you'll get a #NA error. If you don't want the
error, use

=if(isna(vlookup(value,range,column,false)),"No match",
vlookup(value,range,column,false))

"Val" wrote:

Has anyone else had a problem with the lookup formula returning an incorrect
result? I have found that if there is no match, it will return the result
from the previous line. Does anyone have a solution?