Vlookup Erros

KMJ · External Since: Nov 04, 2009 Posts: 1

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 · External Since: Jul 08, 2005 Posts: 16046

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

Bernard Liengme · External Since: Aug 27, 2003 Posts: 146

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" <KMJ.DeleteThis@discussions.microsoft.com> wrote in message
news:EF37D0D4-FC1F-4D3F-98EE-AFB2D53E15D8@microsoft.com...
> 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.