I am trying to link two databases by manually matching the record name
(written in Chinese). However, it's taking way too long due to th
number of records. One useless character that is missing in one of th
names throws off the vlookup!

Does anyone know if there is a Macro available to help do fuzz
matching in a vlookup in Chinese? The difference between a traditiona
vlookup would be to look at the unique combinations between two chines
characters within the name and find the closest match with anothe
name. (since each unique two character combination greatly increase
the chances the two records match) Traditional fuzzy matching yield
completely wrong results.

Thanks

--
frostytil
-----------------------------------------------------------------------
frostytile's Profile: http://www.excelforum.com/member.php...fo&userid=3388
View this thread: http://www.excelforum.com/showthread.php?threadid=53662

frostytile,
I'm no Chinese expert, but there are various ways of sorting in Chinese; by
stroke count or PinYin, so it depends what you mean by "closest match.
The .SortSpecial method may help with this.

So you have something like "apple" and "aple" that you are trying to match ?

NickHK

"frostytile" wrote
in message ...

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!


--
frostytile
------------------------------------------------------------------------
frostytile's Profile:
http://www.excelforum.com/member.php...o&userid=33884
View this thread: http://www.excelforum.com/showthread...hreadid=536623