Ah nevermind, after I had a cup of coffee and reviewed the formula
requirements, I saw the the data in the table I was searching for had to be
in the leftmost column of the table. Once I fixed that problem, it worked
like a charm!!! Thanks again to both of you.

Mark B wrote:
Excellent!!! Thank you both very much, this was driving me bonkers, and I
don't have a lot of extra sanity to spare...it seems as if I am still having
problems since when I do that operation manually I get a different result,
and the result is the sam no matter what cell I tell it to look up.

The only thing I'd add is a ",False" in the formula to ensure the
vlookup finds an exact match rather than the nearest match.
[quoted text clipped - 13 lines]
Grappenhall, Cheshire, UK
__________________________


--
Mark Brindamour
mtbrindamour[AT]hotmail[dot]com


Message posted via http://www.officekb.com