I had a similar problem just today. The value I was looking up was
formatted as text - even though Excel indicated it was a number in the
FormatCells menu.

There is probably a simpler way to fix the problem...but I used a
working cell =VALUE(CellReference) and used that cell for the vlookup
instead...

Hope this helps. But yes....the common sense approach is copy/paste
values....wish I had thought of that :(

/systematic


--
systematic
------------------------------------------------------------------------
systematic's Profile: http://www.excelforum.com/member.php...o&userid=25294
View this thread: http://www.excelforum.com/showthread...hreadid=530448