Compare comma-separated values with look-up values

Hi,
I am looking for a formula (or a vba code) for comparing comma-separated values (columnA) with look-up values from columnB and the result is comma-separated values:
columnA
text1, DE, FR, KR, JP, text2, txt3
txt6,FR
JP, PL, AU

columnB
DE
US
FR
JP
AU

Result
DE, FR, JP
FR
JP, AU

Thanks in advance

N

VBA ..

Please Login or Register  to view this content.

Data in A1 down

Cods in B

in C1 ..

=match_CSV(A1,$B$1:$B$5)