Dave,

Thank you for responding and so quickly. The link was helpful in that I was
not familiar with that site. I had done all of the things that Debra
mentioned, previously, and they did not fix the problem.

--
Andy


"Dave Peterson" wrote:

Debra Dalgleish shares some debugging techniques for the =vlookup() formula:
http://contextures.com/xlFunctions02.html#Trouble

Andy wrote:

I have two data sets each 3 columns wide, I am trying to match the data in
the first set to the second set. Most of the time the vlookup formula I am
using works fine, however, it does not work all the time. There are data
elements in the sets that are not matching. I have tried reformatting the
cells to ensure they are the same. I have the fourth argument set to FALSE to
find an exact match.

I believe I have tried everything I can think of and am very frustrated. Any
help would be most appreciated.
--
Andy

--

Dave Peterson