I've also seen where one number will have a significant digit past the
second decimal place less than 5 so it rounded down, therefore until I
extended the decimals to three or four I could not identify why the
numbers would not 'match'. i.e. one was 1234.0004 and the other was
1234.0000.

Janeen Wrote:
After verifying that the formula is correct, matching cell formats, and
verifying the cell data is an exact match, I continue to get a "N/A"
response
in two cells of my workbook. I've even gone so far as to back out of
Excel,
re-launch the program, and re-open my source file and VLOOKUP file.
Out of
over 1300 matched items, these two refuse to cooperate! Can anyone
tell me
why?

I'm frazzled beyond understanding at this point... (sigh)


--
surg4u1975
------------------------------------------------------------------------
surg4u1975's Profile: http://www.excelforum.com/member.php...o&userid=28718
View this thread: http://www.excelforum.com/showthread...hreadid=496251