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
.