Forum Discussion

DaanvdM's avatar
DaanvdM
Copper Contributor
Aug 25, 2022

Extracting Exact word match with a pre-defined list into an new corresponding column

Good day,   I have spend probably too long trying to figure out this problem. In Sheet 1 there is a list of Brands: BRAND RUWAG ZEBRA EASIGAS AFROX LIBERTY MTS In Sheet tw...
excel
office 365
DaanvdM's avatar
DaanvdM
Copper Contributor
Aug 31, 2022

Thank you Riny_van_Eekelen  and  Harun24HR @. Looks like the formula of Riny_van_Eekelen is the closest to our desired outcome. There is, however, a snag. The formula matches partial matches as well. Let's say the description is Easigas and there are both the Easi and Easigas brands. It matches the first from the top, not necessarily the best match

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 31, 2022

    DaanvdM That's quite a collection of descriptions and brand names you have there. Many don't seem to be related to any brand name to begin with. Like "EXPANSION BOLT 5X50MM" or "EYELET BRASS".

     

    I've played around a bit with PowerQuery and fuzzy matching, but the end result isn't very promising. With a rather low threshold, PQ matches just under 3000 thousand (out of 18000+) descriptions and many of them are obviously very wrong.

    Can you explain what you actually want to get out of this exercise?

Resources