Excel Fuzzy Lookup/Match Tutorial for Data Mapping & Categorization

preview_player
Показать описание

I begin by showing the other lookup functions and then you can see why they are useless when you are dealing with imperfect matching.

Fuzzy lookup is a really useful tool for anyone that needs to do mapping and/or categorization of data that is not very clean. There are all kinds of uses that you may find with this.
Рекомендации по теме
Комментарии
Автор

How does it affect the search, if you add more and more match coloums - I'm trying to have one Exact Match for an User ID and then as well match company names, that are free text on the one hand and a selected company name on the other, but it starts to give me weird results

herrreineckherr
visit shbcf.ru