I have two worksheets. The first worksheet
items has a few rows with unique IDs in column A (item), a lookup list ID in column B (list), a blank column C (choices) where I want my solution to go, and a column D showing my desired output for Column C.
The second sheet
choices contains a column with the list IDs (list) that links to the list ID (list) in the
items worksheet. It also contains a column
choices associated with each list.
What I'm trying to do is concatenate the choices by list (e.g., A, B, C for list1) and display the result in the
items worksheet (Col C choices).
I'm looking for a solution that will update automatically as I add more content to both worksheets. Also, as I continue to review other ideas, it's worth noting that I cannot rely on sorting in my solution.