Home

Fuzzy Lookup Exact match not working!

%3CLINGO-SUB%20id%3D%22lingo-sub-140399%22%20slang%3D%22en-US%22%3EFuzzy%20Lookup%20Exact%20match%20not%20working!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-140399%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%20!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFirst%20off.%20I%20am%20running%20Excel%202013%2064%20bit%20on%20a%20Windows%207%20pro%20system%20and%20i%20have%20i%20problem!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI'm%20trying%20to%20use%20the%20excel%20plugin%20%22Fuzzy%20Lookup%22%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D15011%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D15011%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ein%20the%20config%20menu%20u%20can%20chose%20multiple%20Match%20Columns%20and%20configure%20them%20to%20Default%20or%20Exact%20match.%3C%2FP%3E%0A%3CP%3EIn%20my%20first%20column%20i%20want%20to%20use%20exact%20match%2C%20and%20in%20the%20second%2C%20i%20want%20to%20use%20default.%3C%2FP%3E%0A%3CP%3EBut%20when%20i%20run%20the%20program%20it%20does%20not%20give%20me%20a%20exact%20match%20in%20the%20first%20column!!!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20need%20help%20to%20problem%20solve%20this!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESorry%20for%20the%20bad%20english%20and%20have%20a%20happy%20new%20year!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-140399%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-665053%22%20slang%3D%22en-US%22%3ERe%3A%20Fuzzy%20Lookup%20Exact%20match%20not%20working!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-665053%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20same%20problem.%20For%20example%2C%20I%20want%20that%20it%20matchs%20exactly%20the%20CP%20(with%20first%20priority)%20then%20matchs%20with%20default%20the%20name%20of%20cities.%20It%20means%20that%20i'd%20rather%20prefer%20to%20have%20a%20lower%20similarity%20for%20the%20name%20of%20the%20city%20but%20be%20sure%20that%20it's%20the%20same%20zipcode%20(%20by%20the%20way%20the%20match%20with%20zip%20code%20had%20a%20way%20worse%20results%20the%20exact%20match)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F116997iEABCE4608DAF3C7F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22fuzzy.PNG%22%20title%3D%22fuzzy.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20help%20me%20solving%20this%20problem%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-140439%22%20slang%3D%22en-US%22%3ERe%3A%20Fuzzy%20Lookup%20Exact%20match%20not%20working!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-140439%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20let%20us%20know%20exactly%20what%20you%20want%20to%20do%2C%20i%3CSPAN%20class%3D%22short_text%22%3E%3CSPAN%20class%3D%22%22%3Et's%20better%20to%20give%20us%20some%20screenshots%20and%20samples%20of%20your%20data.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20the%20exact%20match%20or%20default%20match%20to%20get%20a%20result%20as%26nbsp%3Bbelow%20screenshot%20%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F26199i118B28C8CC88DB25%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Fuzzy%20Lookup%20Example.png%22%20title%3D%22Fuzzy%20Lookup%20Example.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-679447%22%20slang%3D%22en-US%22%3ERe%3A%20Fuzzy%20Lookup%20Exact%20match%20not%20working!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-679447%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F353738%22%20target%3D%22_blank%22%3E%40YassineBen7%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20about%20the%20late%20reply!%3C%2FP%3E%3CP%3EI%20tried%20to%20reproduce%20the%20problem%20on%20my%20own%20worksheet%20but%20without%20success!%3C%2FP%3E%3CP%3EPlease%20check%20out%20this%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DIG27sqkIO8w%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Evideo%3C%2FA%3E%20as%20it%20may%20help%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
jeppe nygaard
New Contributor

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/download/details.aspx?id=15011

 

in the config menu u can chose multiple Match Columns and configure them to Default or Exact match.

In my first column i want to use exact match, and in the second, i want to use default.

But when i run the program it does not give me a exact match in the first column!!!

 

I need help to problem solve this!

 

Sorry for the bad english and have a happy new year!

 

3 Replies

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 :

 

Fuzzy Lookup Example.png

@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):

fuzzy.PNG

 

Can you please help me solving this problem?

Thanks in advance.

@YassineBen7

 

Sorry about the late reply!

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

Please check out this video as it may help you!

 

Regards

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies