How Can I Compare Two Columns and Return the Matched Values in a Single Cell?

This question addresses a similar question, however it only returns the first matched value into the cell.

Their proposed formula was:

=INDEX($A$1:$A$5,MATCH(TRUE,COUNTIF($B$1:$B$5,$A$1:$A$5)>0,0))

What I’m looking for is adding multiple matched values into a single cell from those two columns, so:

Let:

The result in Column C should be:

If there were no matched values, then we can leave it blank.

>Solution :

Using FILTER:

="Matched: "&TEXTJOIN(", ",,FILTER(A1:A3,ISNUMBER(MATCH(A1:A3,B1:B3,0))))