Matching Names won't VLOOKUP

Copper Contributor

Deleted

4 Replies

@heffjenry 

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.

 

 

@Sergei Baklan 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!

WORKED! Thank you. @Sergei Baklan 

@heffjenry , you are welcome.

To automate - perhaps there are ready to use export to Excel tools exist. Maybe could be done with Power Query, but that's not 10 minutes job.