I cannot use INTERSECT() between 2 columns of Lists

Please Help!
Hello, I am really a newbie and have a near-zero knowledge of programming language.

In each row, I have 2 columns, the first one contain a list (texts separated by comma), generated by ENUMLIST, and the another one contain a list (texts separated by comma), generated by expression โ€œLIST(LOOKUP(โ€œAโ€, โ€œBBโ€, โ€œAAโ€, โ€œBโ€))โ€.
I want to use intersect() to return the values that common in these 2 list.
But How many time Iโ€™ve tried, it return blanK.

I really have no idea what to do.
Thank you.

0 5 677
5 REPLIES 5
Top Labels in this Space