Forum Discussion
Matching Names won't VLOOKUP
Deleted
Jeff,
In names which you copy/pasted from web there are non-breaking spaces CHAR(160) instead of space CHAR(32), thus no matches in names. Actually I checked only one, "Daniel Jones" - in the middle there is non-breaking space.
Unfortunately that's usual story with copy/pasting of HTML text. You may replace non-breaking spaces on spaces manually - Ctrl+H, into Find what Alt+0160 (number shall be entered from Numpad keyboard), Replace on space, and replace all.
Perhaps there are some other similar characters, I didn't check everything.
SergeiBaklan Thank you so much. Was hoping to just drop in the source data and everything to update automatically each week, appreciate you spotting the issue!