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

What's the formula you're using, and are you sure the subject of the
vlookup i.e. the first term, really exists in your data?

What error message are you getting?

Rgds

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________