Hi Guys,

I am currently working with huge data ranges and have been comparing my client database with another source to basically fill in any missing information. currently I am comparing the address Data sets, I have used fuzzy lookup before to compare 2 smaller tables and give me a comparison on the two data tables but as the two sets of data are currently side by side and matched this isn’t much use.

how would you overcome this issue? is there any formulas that I am not aware of that will return a match percentage on say address line 1 from data set 1 and line 1 from data set 2?


Address Data 1

address Line 1 | Address line 2 | Address Line 3 | Address Line 4 | Postcode |
11 Long Road | | | | cm4 9gg |

Address Data 2

address Line 1 | Address line 2 | Address Line 3 | Address Line 4 | Postcode |
11 Long | | | London | | |

Look forward to your response

Thanks

Turtlesrun