Trying to find Data to Match

[ctackett6407]

Greetings Everyone!

I've been learning a lot since I have been a part of this community and I want to say thank you!

I have another question that I'm going to go in and try what I know and see how that goes, but if someone has a better suggestion, I'm all ears!

We currently have three different sources of data. They do not work well with each other; however, I think if we can tie a standard data set between them then it will be a GREAT tool for us to use.

I just exported one of the sources moments ago and found it has around 60k rows of data in it. I'm trying to compare addresses from one file to addresses I pull from our primary data source and try to see if I can compare those. That's the only thing I can see that MAY be comparable.

The problem is that the addresses from the two sources I want to compare may be spelled a little different or use "west main street" or "w main st" etc.. variants.

I might try to compare the county and the zip code as well to ensure that if the service address matches that it "really" matches because there's only one address in a city, as far as I know.

I have not seen several addresses of 123 Main Street in the same zip code.

Anyway, Anyone knows or where I can learn more about trying to create a formula that will let me search addresses that might have variants in it?

 

[Yongle]

You could try the free Microsoft Fuzzy Lookup Add-In (compatible Excel 2007 onwards)