Hi,
Just got back from lunch.
I did the If function, and it did return as different. That is interesting.
However, I did the LEN function, results were 15.

How do I send the file to you?
MrRJ

"Sheeloo" wrote:

Assuming you have your 15 digit nos (original and copied from other sheet) in
A1 and A2
try this in an empty cell
=IF(A1=A2,"Same","Different")

You will, most likely, get "Different"

Try this
=LEN(A1) and see if it is 15. There might be a blank.

Send the file to me... I will take a look.

"MrRJ" wrote:

Hello,
I have a file with two sheets. One the second sheet, I am using a vlookup
to find values in the first sheet. Simple enough. However, I came across a
unique problem that I have never encountered.

The result I recieved was #n/a. Now, the value does exist from both sheets,
even using the find function, it works. When I copied the value from the
first sheet to the second sheet, it returns a valid value, not #n/a. I don't
understand why? As you can in this example, the 15 digit numbers are the
same, but produces two different answers. They should be the same! Format
should have nothing to do with it, correct? I hope that this is simple for
you to answer.

330000050001068 1.00% 4 (I copied the 15 digit from sheet 1)
330000050001068 #N/A #N/A (Originial 15 digit value from sheet 2)

Help Please.
MrRJ