Vlookup Erros
 

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.

Vlookup Erros
 

Can you share the data and show the VLOOKUP formula?
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"KMJ" wrote in message
...
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.

Vlookup Erros
 

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.

KMJ wrote:

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.

--

Dave Peterson