0

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.

enter image description here

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.

enter image description here

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.

4
  • What excel are you using? If not the latest Office 365 then it will require vba. May 19, 2016 at 15:57
  • thanks. Excel for Mac 2011, 14.6.3. i could upgrade if the solution is easier.
    – Eric Green
    May 19, 2016 at 15:58
  • No, the TEXTJOIN() Function is not available on the Mac. It will require vba. May 19, 2016 at 15:59
  • ok, thanks. any tips on how to go about creating the vba solution? relevant examples maybe?
    – Eric Green
    May 19, 2016 at 16:01

1 Answer 1

0

If you can live with sorting in choices, then this appears to work:

enter image description here

enter image description here

h/t: http://www.exceltactics.com/combine-data-multiple-rows-one-cell/5/

2
  • You stated it's worth noting that I cannot rely on sorting in my solution. hence the vba is the only route statement. If you were okay sorting then I would have suggested this method. May 19, 2016 at 16:21
  • that makes sense. i'm looking for a non-sorting option, but i figured i would post this as a partial solution.
    – Eric Green
    May 19, 2016 at 16:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.