Forum Discussion
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 ...
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)
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. 🙂
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. 🙂
Got it.
I strongly offer you to watch Ken Puls's video and use Left Out Join option in Power Query to solve this issue.
https://www.youtube.com/watch?v=7Xc1fUsk--c&t=23s
From 54's minute to 106's minute.
Good luck
oh wow Thanks!!!
Please check attached file.
I think it should be answer to your question.
To get more correct answer change ratio seen on picture (Power Query Fuzzy Matching)
It can be from 0 to 1. Default is 0.8