EDITED...
you chould think about using SUBSTITUTE, ie:
SUBSTITUTE(A2,CHAR(160),"")
It's not clear from your post whether you're using these values as criteria in your VLOOKUP or they are the left most column of the range... so it's hard to provide further insight.
EDIT: Nice tip NBVC.
Bookmarks