Just to add a little bit here

You posted

I have tried reformatting the
cells to ensure they are the same.

You can't just reformat the cells, you have to CONVERT them
from text to numbers.

You can read all about it at the link that Dave posted.

HTH
Martin





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