Hi

=VLOOKUP("*Blue*",A1:B20,2,FALSE)

Mike

"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?