Look things up
List every match in one cell
=TEXTJOIN(", ",TRUE,FILTER(B2:B5,A2:A5=E2))How it works in Excel
- FILTER keeps the rows that match.
- TEXTJOIN joins them with commas.
- It needs Excel 2021 or Microsoft 365.
The idea in general
You collect every hit, then write them out as one list.
What I assumed
- The list is in A2:A5, the values are in B2:B5 and the item is in E2.
Check the result on your own data before relying on it.