I need help with showing a list of items as shown in cell D3 of this doc. I don't know if the if statement is adequate for this.

CodePudding user response：

Is this what you were looking for? =IFS(E1= 1, JOIN(",",A2:A5),E1= 2, JOIN(",",B2:B5))

Thanks