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