May 26 2021 10:51 AM
Hello, I have a question
I have some data from the question of "what fruit do you like?"
Some of the answers have several choices of fruit
So, what IF formula can be used for multiple options in one cell?
I attach the excel file
Thank you
May 26 2021 12:18 PM
May 26 2021 01:02 PM
As variant
with
=TEXTJOIN("; ",1,IF(COUNTIF(XLOOKUP(G3,$A$3:$A$8,$B$3:$B$8),"*"&$E$4:$E$7&"*"),$D$4:$D$7,""))