I have a sheet of activities that looks something like this
|Activity Name||Category Ids|
|Activity 1||123456, 98756, 345677|
I have a second sheet of category ids
|Category Id||Category Name|
Here's a link to a sample spreadsheet
What I would like to do is create a column in the activity sheet that displays the names of all of the categories that are in the category Ids field for that activity.
Is this possible in Google Sheets? So far, I haven't even been able to get a simple lookup to work on multiple id's in the id's field (see my spreadsheet). I've also looked at this article on implementing multiple-select dropdown lists, but haven't implemented it because I am not sure how to deal with the fact that in my case, the dropdown list needs to be pre-populated with the values already in Category IDs.