Create list of items depending on responses in a quiz in excel

Viewed 14

I have a questionnaire in Excel that depending on the answer will have a final list of items.

For example:

Question 1 if answered with YES there will be CAT in the list, otherwise Dog.

Question 2 if answered with YES will have Parrot in the list, Otherwise Elephant.

I would like to create a conditional for these questions and create a single cell with the final list.

It would be like Python's append() but in excel lol

Thanks

0 Answers
Related