Method to Match two sheets based on a field that does not 100% match

[spectraflame]

I have two different sheets that I need to combine but they do not have an exact for the address field. I know there is no way to get an exact match for all records.

Some have values like:
- 123 Main St vs 123 Main Street
- 5900 County Road vs 5900 Cty Rd

Anyone have an suggestions on how to better prepare the data to match upon? Unfortunately there are no other fields between the 2 tables that can be used for the matching.

 

[CA_Punit]

So we can do one thing we can filter out data.

I mean say we can check that if two or more words match then it can be assumed that the details are same. Also it can be done that the first word should always match the first word in the look-up cell.. This might filter you data to small manually to-do task

 

[spectraflame]

So we can do one thing we can filter out data.

I mean say we can check that if two or more words match then it can be assumed that the details are same. Also it can be done that the first word should always match the first word in the look-up cell.. This might filter you data to small manually to-do task

Is this filter process using the DATA > FILTER option and then using various TEXT filters?