I am trying to link two databases by manually matching the record names (written in Chinese). However, it's taking way too long due to the number of records. One useless character that is missing in one of the names throws off the vlookup!
Does anyone know if there is a Macro available to help do fuzzy matching in a vlookup in Chinese? The difference between a traditional vlookup would be to look at the unique combinations between two chinese characters within the name and find the closest match with another name. (since each unique two character combination greatly increases the chances the two records match) Traditional fuzzy matching yields completely wrong results.
Thanks!
Bookmarks