How to concatenate all occurrences of a Google Sheets Query

Question

I have two columns of data and one other column which contains the search key. I am trying to fetch all results that contain a specific text which I'm able to do. The challenge is that I need to concatenate all the occurrences into one single cell.

I have tried the following formula: =ARRAYFORMULA(IFERROR(VLOOKUP(F2:F,B:C,2,FALSE),""))

Which works but halfway through. So what remains is fetching all the other results into one cell. Currently, it's only fetching a single result.

In this image, the desired output is in F2 for the search key Paul in E2.

Link to my spreadsheet. https://docs.google.com/spreadsheets/d/16GujlPIn3sqh4DX-taG5b65futHBJrgi6rNmj5zNmdM/edit?usp=sharing

question from:https://stackoverflow.com/questions/65850391/how-to-concatenate-all-occurrences-of-a-google-sheets-query

Answer 1

use:

=JOIN(,FILTER(B:B, A:A=E2))