+ Reply to Thread
Results 1 to 11 of 11

Fuzzy Lookup - More than 1 match

  1. #1
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Fuzzy Lookup - More than 1 match

    With the Fuzzy Lookup algorithms, which search for an approximate match, has anyone come across anything which gives more than one result.
    The code below gives one result.

    Please Login or Register  to view this content.
    Capture.PNG
    Attached Files Attached Files

  2. #2
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Fuzzy Lookup - More than 1 match

    I've put up a searchable dropdown list here before which is similar to what you seem to be looking for. No fuzzy logic though.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Fuzzy Lookup - More than 1 match

    OK thanks, I'll see if I can use the logic in Visual Basic.

  4. #4
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Fuzzy Lookup - More than 1 match

    Just quickly looking at your code though, it seems that if you extend your 'Value' string for each match... Value = Value & "," & str
    if should give you more like what you want.

  5. #5
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Fuzzy Lookup - More than 1 match

    I can't seem to work through it.

  6. #6
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Fuzzy Lookup - More than 1 match

    ok...I had a bit longer to look at your code and it didn't find matches based on the characters I looked for, so I've made some suggestions for you.

    You may want to tidy it up and tweak the magic number, but I've tried to stick as close as possible to your original algorithm.

    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Fuzzy Lookup - More than 1 match

    Thanks Croweater but I couldn't see how more than one result is given.
    I tried another way which is to use a Levenshtein distance function commonly shown in a browse search, which returns a number. I go to the point of creating an array of results, and then re-ordering this array.
    There is an issue with the order though because it looks at the leading digit first, so a value of 10 is treated as smaller than a value of 9.

    Please Login or Register  to view this content.

  8. #8
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Fuzzy Lookup - More than 1 match

    What do you mean "I couldn't see how more than one result is given."?

    Did you try the code with the modifications?

  9. #9
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Fuzzy Lookup - More than 1 match

    Yes I did try it. It doesn't seem to fill in ranges B3 to B6.

  10. #10
    Spammer
    Join Date
    10-23-2012
    Location
    Adelaide, Australia
    MS-Off Ver
    Excel 2003, Office 365
    Posts
    1,237

    Re: Fuzzy Lookup - More than 1 match

    Well it all depends on what you typed in as a search string and how closely it matches the names in the search doesn't it.

    If you search for 'L Bird' for example it will only find one match. If you search 'Bill' though it will find more.

    If you want to be less stringent with the search, lower the 'magic number' in the code.

    Did you try multiple searches?

  11. #11
    Forum Contributor
    Join Date
    11-10-2009
    Location
    Perth, Australia
    MS-Off Ver
    Excel 2007
    Posts
    548

    Re: Fuzzy Lookup - More than 1 match

    Yes you're right, sorry about that.
    For some reason I couldn't work through this one.
    Thanks for the providing code.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Fuzzy Vlookup Help (Can't get longer strings to match simplified lookup)
    By rosetc16 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-10-2020, 11:54 AM
  2. [SOLVED] Fuzzy Lookup
    By RSRSRS in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-20-2019, 04:36 PM
  3. Fuzzy match formula to match partial email string in another list?
    By Akshay in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-26-2018, 01:51 PM
  4. Replies: 1
    Last Post: 08-24-2015, 10:42 AM
  5. fuzzy lookup add on, specifying what to match against
    By IronCladRooster in forum Excel General
    Replies: 0
    Last Post: 08-14-2014, 10:06 AM
  6. Using Fuzzy lookup add in
    By akshaykadidal in forum Tips and Tutorials
    Replies: 1
    Last Post: 01-07-2014, 08:21 AM
  7. Cell search fuzzy word match lookup
    By datacruncher in forum Excel General
    Replies: 1
    Last Post: 12-03-2009, 07:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1