Forum Discussion
How to match and assign a word to a letter in a cell
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.
With Riny_van_Eekelen 's data you can add another blue dynamic table where you enter the descriptions. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
- 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 muchThis 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