Forum Discussion
How do I return multiple continents for multiple countries?
I have a list of soft drinks being sold in different countries. I want to return the continents for them. i.e. Soft drink | Countries | Continents Coca cola | China, Denmark, Italy, Australia | ...
try this
=TEXTJOIN(", ";TRUE;(UNIQUE(XLOOKUP(TEXTSPLIT(C3;", ");$F$3:$F$8;$G$3:$G$8;0);TRUE)))