Vlookup for two lists from different sources

[ExcelQuestion]

I have two sets of lists. Each contains names of companies. The problem is
that the lists come from two sources, and thus are not the exact same (i.e.
some have Co., Inc., etc.). I need to make these names match on both lists?
How can I do this?

Thanks.

[Bernie Deitrick]

Sometimes, only manually. But for some cases, you can use a function that returns an index that can
be used to find some close matches. Visit

http://www.j-walk.com/ss/excel/tips/tip77.htm

for details.

HTH,
Bernie
MS Excel MVP


"ExcelQuestion" <[email protected]> wrote in message
news:[email protected]...
>I have two sets of lists. Each contains names of companies. The problem is
> that the lists come from two sources, and thus are not the exact same (i.e.
> some have Co., Inc., etc.). I need to make these names match on both lists?
> How can I do this?
>
> Thanks.