Help: The same text but can not error return by VlookUp

[yurble_vn]

Hi ALl,

I have a text column which pasted from web. But when used vlookup to search for text that exactly typed, it always returned N/A.

When I copy and pasted value manual, the text, it works.

Please help me understand the case (please attached files)

[Bob Phillips]

That is because the entry for maxxum in your list in column B has a tariling space. Get rid of it and it works fine.

[yurble_vn]

Thanks XLD, have not noted about that.

Thanks much for prompt support