I have a basic vlookup formula set up so that if you type a code in a cell, it defines the code in the cell next to it based on data in another worksheet.
Is it possible to put multiple codes in a cell and the output in the next cell would be each description separated by a comma?
For example:
Table Data
72281 postlaminectomy syndrome, cervical region
7840 headache
71941 shoulder pain
In one cell I’d like to enter “72281,7840,71941” and in the cell would output the discreptions as “postlaminectomy syndrome, cervical region, headache, shoulder pain”
Also note that there could be any number of codes in a cell, not just 3.
Is this possible?
Bookmarks