I have 2 columns of values. I want to create a formula that looks at Column A and finds what Column B text values are within in the Column A items. Then I want what matches to list in column C. I've posted an example below.
|Column A Apples List||Column B Categories||Column C Results|
|Pink Lady and Honeycrisp Apples||Fuji||Honeycrisp|
|Fuji and Honeycrisp Apples||Honeycrisp||Fuji, Honeycrisp|
|Gala and Honeycrisp Apples||Golden Delicious||Gala, Honeycrisp|
|Golden Delicious and Fuji||Fuji, Golden Delicious|
I've tried the following but this does not work and shows no matches.
=TEXTJOIN(", ",TRUE,IF(A2=$B$2:$B$4,$B$2:$B$4,"no matches"))