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.
Eqa33 I would do that with Power Query. See attached.
- But how do I do that and then how does T become Tyre, and B become Bat, and C become Cap, etc?
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 much
