Which columns are you matching?
Assuming both sheets have Col A,B and C... are you matching on A&B&C?
if yes then have this in both D cols
=A1&B1&C1 and copy down
then in one sheet in E1 enter
=VLookup(D1,Sheet1!D:D,1,False)
If they still don't match then paste the formats from one sheet to the other
by selecting the whole sheet and painting the other
Next copy row 1 from sheet 1 to the row 1 of sheet 2...
They should match then... :-)
It might tell you what was wrong...

or just send the file to me :-)

"Andy" wrote:

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