Hey everybody,
I’ve got a workbook in the attachment containing 2 worksheets, “output” and “input”.
Worksheet “Output” contains concatenations of codes (i.e.: F090+M014+427) for which I need their descriptions from worksheet “Input”. The descriptions however are available for individual codes (i.e.: the description for “F090” is “Towels / Hips”)
Therefore what the code should do is the following:
Separate in background the concatenations of codes from column “Codes” in worksheet “Output” and look up and pick the corresponding code description from column “Description” – worksheet “Input”. The results corresponding to each code should be concatenated (separation symbol “/”) in column “Concatenation”- worksheet “Output”.
My attempts till now have been unsuccessful; therefore your support is highly appreciated!
Thanks a lot!
Bookmarks