Forum Discussion
Solved
How to match and assign a word to a letter in a cell
Hi There, I have a column of product numbers, within each number is one letter that represents the type of product it is. How do I marry that letter up to a description from another list so that I ...
Eqa33 You missed the most important part and that is that you need to extract the one Letter from the code first. You are now trying to merge the full product code in the Sales table with the category code in the Category table. Obviously, that's not going to return any match.
I've added the step that extracts the code and changed the merge query. It works now.
Sorry,but you need to expand your explanation. The end result you show is correct and what I want to achieve but what is the formula or process to look it up and extract the info?
Thanks very much
Thanks very much
This is done with Power Query. You can start the Power Query Editor as shown in the screenshot.
Then you can follow the applied steps within the Power Query Editor. "Angewendete Schritte" are the applied steps of the query. You can click on every step from "Source" to "Description" in order to follow the transformation of the data.
If you want to know more about Power Query i'd recommend this site:
OliverScheurich Ok, now I understand. But I have a problem when I merge the query I cannot I get a recognition of the letter buried in the middle of the product number it just produces a column of null and as consequence the category name is all null as well. What am I doing incorrectly? Thank you
Eqa33 Added a few steps to your query. These extract the letter codes and merge them with the ones in the Code table. See if this does what you need.
- Thanks for your answer. I am obviously doing something wrong. When I merge the 2 tables as you have shown I get null in every row. What am I doing incoirrectly?
