Forum Discussion

jeppe nygaard's avatar
jeppe nygaard
Copper Contributor
Dec 29, 2017

Fuzzy Lookup Exact match not working!

Hi all !   First off. I am running Excel 2013 64 bit on a Windows 7 pro system and i have i problem!   I'm trying to use the excel plugin "Fuzzy Lookup": https://www.microsoft.com/en-us/downl...
BI & Data Analysis
excel
YassineBen7's avatar
YassineBen7
Copper Contributor
Jun 03, 2019

Haytham Amairah 

 

I have the same problem. For example, I want that it matchs exactly the CP (with first priority) then matchs with default the name of cities. It means that i'd rather prefer to have a lower similarity for the name of the city but be sure that it's the same zipcode ( by the way the match with zip code had a way worse results the exact match):

 

Can you please help me solving this problem?

Thanks in advance.

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Jun 09, 2019

YassineBen7

 

Sorry about the late reply!

I tried to reproduce the problem on my own worksheet but without success!

Please check out this https://www.youtube.com/watch?v=IG27sqkIO8w as it may help you!

 

Regards

 

Resources