Excel 2002 Lookup formula returning wrong results?

V

Val

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?
 
D

Duke Carey

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))
 
Top