Sounds like the data format is not what you think it is.

If you think a cell is a number try this to validate =ISNUMBER(cellref) TRUE
or FALSE is returned.

If a number is formatted as text, simply re-formatting will not change it.

You must force a change to make it a real number.

Format all to General.

Copy an empty cell and select your data range.

EditPaste SpecialAddOKEsc

If that doesn't work, maybe you have some extra spaces in the data.

Try running =TRIM(cellref) to remove.


Gord Dibben MS Excel MVP

On Wed, 20 Sep 2006 14:21:01 -0700, Hopeful
wrote:

I have been working with vlookup tables for a while now but when I started a
new one with some new date from another source, it stopped working. It will
not return values that I ask it to lookup. The date is both numerical and
text. I have sorted the date in ascending order. I have tried changing the
data from number to text to general. Nothing seems to work.

If I open another sheet up and try to a vlookup it works. It is just not
working with my new data.

Thanks