VLookUP doesn't always returns the value from another list

[GN0001]

My VLookUp doesn't return all the values while I know that my look up value exists in both sheet.

I use code(cell) to get the number of the invisible character

It gave me values: such as: 53, 143 and so on


I used the top values in substitute function to remove unwanted characters,

=Substitute(substitute(text, char(143),""),"","")


Then my VLookUp returned values.


however, I did the same thing today and I received a bunch of values but not all the values returned to me, still I received a lot of #N/A while I am certain that my LookUp Values are in both list.

How can i fix this problem?

My values are:

Sheet 1: Sheet2:

MM100098 MM100098

000456 000456

RR34567 RR34567

Regards,

GGGGG

 

[Faseeh]

Hi GGGGG,


I suggest you to upload a sample file for this case because only we will be able find what is causing problem, when i will set formula for your given sample, there is posibility that those problematic-characters might not be present in this.


Regards,

Faseeh

 

[GN0001]

Ok, I will post my question and upload the file again if the problem persists. I have to go back to work on Monday to see what the problem is.

regards,

GGGGG