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
Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Dec 29, 2017

Please let us know exactly what you want to do, it's better to give us some screenshots and samples of your data.

 

You can use the exact match or default match to get a result as below screenshot :

 

  • 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