Vlookup Erros

K

KMJ

Recently in Excel 2007 we, those in my office, have been receiving random
results when trying to use a vlookup even on the most basic of dada. These
are simple two column data ranges. We have previously setup vlookups that
still function however new ones do not give accurate consistent results.
 
D

Dave Peterson

My bet (and it's just a guess) is that you want to have an exact match, but your
formula doesn't tell excel to do that.

=vlookup(a1,sheet2!a:b,2,false)
or
=vlookup(a1,sheet2!a:b,2,0)

That 4th parm (false or 0) tells excel to look for an exact match between the
value in A1 and column A of sheet2 (the first column of that look up range).

If this doesn't help, you should share more details--including the formula
itself.
 
Top