PDA

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



yurble_vn
11-18-2007, 03:53 AM
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
11-18-2007, 04:31 AM
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
11-18-2007, 04:36 AM
Thanks XLD, have not noted about that.

Thanks much for prompt support :thumb