Extract unique names (names could be little different)

hello ,

If I have 2 lists:

The first one contains the following

America Co INC
Chicago Line Co
New York Corporation
First house Inc

and the scond ones contains:
America Corporation INC
Chicago Line Corporation
New York Corporation
1st house Inc

How do I extract the unique values or in other word the same business since spelling is little different? I would appreciate your help. thank you

Try using the MATCH() function

If the value is in the range MATCH() returns a number
If the value is not in the range MATCH() returns #N/A.
Thus you can use the ISNUMBER() function to check the result returned by MATCH() as follows:

Please Login or Register  to view this content.

Hope this helps.

Mark.