Approximate match on string of text
You could also try MATCH() function which returns the row number as below.
Again with the first 10 chrs...
=MATCH(LEFT(B1,10) & "*",A:A,0)
If this post helps click Yes
---------------
Jacob Skaria
"Pierre" wrote:
Sorry, I was not precise enough. I would like to flag the names in the first
list that are "close enough" to any name in the second list.
It is a kind of VLOOKUP but with a bit of "fuzzy logic" in it.
"Dennis Tucker" wrote:
I would assume that when you match €śBlue Circle Productions€ť with €śBlue
Circle Production€ť, you would delete one or the other entry. Is that right?
Are you merging the two lists?
Dennis
"Pierre" wrote in message
...
I am looking for a solution to the following problem: I have a long list
of
companies in an EXCEL sheet, and would like to find, company by company,
if
there is an approximate match with a name in another long list.
Concretely, I would like to be able to match €śBlue Circle Productions€ť
with
€śBlue Circle Production€ť. Any idea? How would I set the degree of
tolerance?
|