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.