Finding similar names, but not exact.

SCWI

New Member
Joined
Jul 24, 2007
Messages
7
I am currently working on two files with similar data. There are lists of client names that I am trying to match, however they are different in small ways (capitalization, abbreviations, etc.). Is there any way to vlookup (or some other function) similar names so that I don't have to go through each client one by one in order to match their names?

Example: One list says Ashland, Inc. and the other file has Ashland Inc. Therefore, when I try to do a vlookup to list all common names within the two files, they error out. I would like to try and find a way to filter common names so I don't have to go through each one individually. Any help would be greatly appreciated as it will save me lots of time. Thanks.
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

SCWI

New Member
Joined
Jul 24, 2007
Messages
7
Thanks for your reply, but does this function work in Excel 2003? I tried entereing in the fuzzyvlookup, but can't seem to get it to work.
 

Joe Was

MrExcel MVP
Joined
Feb 19, 2002
Messages
7,539
It will only run from a Standard module, like: Module1


Try this:

=IF(MATCH("*Tom*",A1,0)=1,A1,"")

If you copy this down it will show any values in that cell if any of thouse values are "Tom"
 

Forum statistics

Threads
1,181,730
Messages
5,931,716
Members
436,800
Latest member
abowalid98

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top