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 ...
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
- i like it more formula base since ill be dealing more of this everyday. Thanks for the answer and knowledge!