Forum Discussion

Toryo0306's avatar
Toryo0306
Copper Contributor
Nov 20, 2020

Confused look up match function

Hi!   I want to look up for a similar value in Column G from Column A.    For example:  Column A has "Retail and Distribution" so I want to match it with Column G as "Retail" and return it like ...
excel
Formulas and Functions
Ilgar_Zarbaliyev's avatar
Ilgar_Zarbaliyev
MCT
Nov 20, 2020

Toryo0306 

 

I need a little bit more detailed explanation.

 

However, I made unique lists of two columns.

 

 

P.S. It seems to me that your request can be solved with Power Query Fuzzy Matching Option (After your explanation)

 

 

  • Toryo0306's avatar
    Toryo0306
    Copper Contributor
    Nov 20, 2020
    Thanks for the answer! Im trying to match a set of strings to a list of strings.
    This is because there are some value in a cell that has different strings.

    Example: the result should be "RETAIL" but I have cells that has "RETAIL AND WHOLESALE", "RETAIL AND COMPUTERS".

    Other example: result should be "Computers and Technology", but I have cells that has "Computer manufacturing" or "Computers and infomation"

    Hope this helps. 🙂

Resources