Trying to match addresses that may not be exact

[JASIAH09]

Hi,

I am trying to match addresses on two files so I can retrieve the corresponding account number. Vlookup worked great for over 2000 records but now I have around 900 where the addresses may be close but not exact. Such as Ave vs. Avenue or Street vs. St. etc. Any help is much appreciated.

example
Sheet 1 Column C2:C3225 Match to Sheet2 F2:F2398, Column Index is 2

Address <tbody> </tbody><colgroup><col></colgroup>
8158 E. Fulton St. Unit C <tbody> </tbody><colgroup><col></colgroup>
8158 East Fulton Street Unit C

<tbody>
</tbody>

 

[Dr. Demento]

I believe what you're looking for is called fuzzy matching. Here are two places to start: http://www.mrexcel.com/forum/excel-questions/195635-fuzzy-matching-new-version-plus-explanation.html and Data Analysis Toolkit: Fuzzy String Comparison in VBA

 

[JASIAH09]

Thank you! Is there a formula for that?

 

[Dr. Demento]

AFAIK, those are VBA solutions in the background.