How to download, install and use fuzzy lookup in EXCEL to clean data. Fuzzy matching addresses from 2 different data sources.
Approximate matching of data tables in EXCEL using Fuzzy Lookup.
Download site:
https://www.microsoft.com/en-au/download/details.aspx?id=15011
Check out my other playlists below:
PIVOT TABLES:
https://www.youtube.com/watch?v=RufENOZErg8&list=PLgl7Zr5nCpaYNddYZOI1jGuPvwCqO4gIm&pp=gAQBiAQB
EVERYTHING about the FILTER FUNCTION:
https://www.youtube.com/watch?v=1_OcLXaWXbo&list=PLgl7Zr5nCpaZCAc88UFN9Wq4UZTs9M1ud&pp=gAQBiAQB
EXTRACT first word, 2nd word, last word, numbers, letters:
https://www.youtube.com/watch?v=WJAuBmx2fYA&list=PLgl7Zr5nCpabXlOHmdEdFXHNrydiQAjtg&pp=gAQBiAQB
2 MINUTE Formula:
https://www.youtube.com/watch?v=k0ww0aGFeoE&list=PLgl7Zr5nCpaYb-X_avUQ6dLJRPpf2UV2l&pp=gAQBiAQB