Return elements in list A if duplicates found in list B

[mrblister]

Hello,

I need a formula that returns an array of matching elements of list A, IF duplicates of it's values are found in list B.

LIST A (source list)	LIST B (list to check against)
hello	well
there	hello
my	are
partner	you
	my
	partner
	today

So I'm looking for a formula that will return an array that contains {hello,my,partner}.

Note: Output must maintain the list order (e.g. so {my,hello,partner} or {partner,my,hello} are incorrect). And the formula must return an array (as I need to run additional calculations on it in a cell).

Can anyone assist?

 

[kevin9999]

Would either of these suffice?

Book1
	A	B
1	LIST A (source list)	LIST B (list to check against)
2	hello	well
3	there	hello
4	my	are
5	partner	you
6		my
7		partner
8		today
9
10	Array match 1	Array match 2
11	hello	hello,my,partner
12	my
13	partner
Sheet2

Cell Formulas
Range	Formula
A11:A13	A11	=FILTER(A2:A8,ISNUMBER(XMATCH(A2:A8,B2:B8,0,1)))
B11	B11	=TEXTJOIN(",",TRUE,FILTER(A2:A8,ISNUMBER(XMATCH(A2:A8,B2:B8,0,1))))
Dynamic array formulas.

 

[mrblister]

Yes, thank you! Solution A was what I was looking for, but your inclusion of solution B is appreciated! Cheers!

 

[kevin9999]

Happy to help, and thanks for the feedback