Vlookup Erros

  • Thread starter Thread starter KMJ
  • Start date Start date
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.
 
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.
 
Back
Top