Excel 2002 Lookup formula returning wrong results?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup returning wrong results 0
match formula 2
LOOKUP returning wrong values 2
TYPE function 3
sun results of a vlookup across a range 3
lookup formula unexpected results 8
Lookup returning incorrect result 1
Lookup against concatenated source value 2

Back
Top