I need to lookup multiple values in Excel, but LOOKUP only returns one value.
See my example where 3 persons perform activity "D":

Column: A B C D E F G H
Row 1: Person: JB JA OA EB AM CJ TG
Row 2: Activity: F D A D K D S

Question: Search for 'D' in row 2
Answer: Result from row 1: JA, EB, CJ

But how can I ask Excel to find these 3 persons, performing activity 'D'
I prefer the result in one cell separated by commas.