Prev: Footnotes in Excel?
Next: Can I copy a combo box in Excel 2002 with a relative cell link?
From: James on 16 Feb 2005 06:03
Hello everyone,

does anyone know of an application or vb code that can be
used to search in two worksheets (like VLOOKUP) on
similar matches using fuzzy logic? For example, if on
one sheet I have I.B.M and the other IBM or James Smith
on one and Jim Smith on the other, is there anyway of
giving confidence codes to the match?

Thanks very much for your help,

James
From: Dave O on 16 Feb 2005 09:47
AFAIK this does require VBA code. I wrote an Access utility in VBA
that does exactly this chore: it works by scrubbing punctuation out of
each list, then comparing each "word" ("Ed" and "Begley" and "Jr" are
each words in this context) in each entry in list A to each word in
each entry in list B. The output is an integer number corresponding to
the number of word matches found.

From: CyberTaz on 16 Feb 2005 11:39
Hello James-

Based on the nature of your data, it could be possible that VLOOKUP uses
logic "fuzzy" enough as it is. If the lookup values include many similar
entries, though, that may not be the case.

Forgive me if you are already aware of this, but although the fx does look
for an exact match, but it uses the preceding row once it finds an item that
is "higher" than what it is looking for. The key is that the lookup table
must be sorted in ascending order based on the first column.

FWIW |:>)
"James" wrote:

> Hello everyone,
>
> does anyone know of an application or vb code that can be
> used to search in two worksheets (like VLOOKUP) on
> similar matches using fuzzy logic? For example, if on
> one sheet I have I.B.M and the other IBM or James Smith
> on one and Jim Smith on the other, is there anyway of
> giving confidence codes to the match?
>
> Thanks very much for your help,
>
> James
>
From: James on 16 Feb 2005 11:47
Thanks for your help.

James
>-----Original Message-----
>Hello James-
>
>Based on the nature of your data, it could be possible
that VLOOKUP uses
>logic "fuzzy" enough as it is. If the lookup values
include many similar
>entries, though, that may not be the case.
>
>Forgive me if you are already aware of this, but
although the fx does look
>for an exact match, but it uses the preceding row once
it finds an item that
>is "higher" than what it is looking for. The key is that
the lookup table
>must be sorted in ascending order based on the first
column.
>
>FWIW |:>)
>"James" wrote:
>
>> Hello everyone,
>>
>> does anyone know of an application or vb code that can
be
>> used to search in two worksheets (like VLOOKUP) on
>> similar matches using fuzzy logic? For example, if on
>> one sheet I have I.B.M and the other IBM or James
Smith
>> on one and Jim Smith on the other, is there anyway of
>> giving confidence codes to the match?
>>
>> Thanks very much for your help,
>>
>> James
>>
>.
>
From: anonymous on 16 Feb 2005 11:47
Hi Dave,

I don't seem to be a
>-----Original Message-----
>AFAIK this does require VBA code. I wrote an Access
utility in VBA
>that does exactly this chore: it works by scrubbing
punctuation out of
>each list, then comparing each "word" ("Ed" and "Begley"
and "Jr" are
>each words in this context) in each entry in list A to
each word in
>each entry in list B. The output is an integer number
corresponding to
>the number of word matches found.
>
>.
>
 |  Next  |  Last
Pages: 1 2
Prev: Footnotes in Excel?
Next: Can I copy a combo box in Excel 2002 with a relative cell link?