Vlookup

[XL_Newbie]

Update 2: ACTUALLY, I still need help PLEASE. Oops! Sorry for jumping to conclusion a bit too early there.
I thought deleting a space after the number fixes the problem. So I used the TRIM function and still not working.
Here's what I found it to work. All I had to do is place my cursor any where in the cell (FYI: appears to be no trailing space at all) and clicked away or just hit enter key and it worked every time.
I don't even have to delete anything.

Please help me figure out how to handle this when I have hundreds of rows to deal with. Thank you.


Update 1: PLease close this post. I found my problem after reading the thread below. There appears to be a space behind these sets of numbers. The function works fine after I deleted the space. Thanks.
http://www.excelforum.com/excel-gene...t-columns.html



HEllo - Good forums and thanks in advance for helping me on this.

I created a very simple vlookup table (attached) as an example so someone can help me figure out what the issue is.
Issue is having to do with exported data/numbers. Vlookup works fine if I manually re-entered same exact numbers.
I have tried to copy the whole column and pasted as 'numbers' into new column but still will not work. I have hundreds of rows to handle so
really need to find out the solution. Please help. Thank you.

P.

[vlady]

hello
try this one.
paste special,values, multiply..
here are the steps in side the sample file.

VLOOKUP_Issue.xlsx

hope this help.

[XL_Newbie]

Thank you much vlady. that works fine for me and the star was clicked as well.

P.