I have a fairly simple spreadsheet where a list of names will have made a meal choice from a list which is shown by a ticked checkbox in the corresponding column.  What I would like is to have a list of what each individual person has chosen without having to type it out manually.  Is this possible?

Example below –  where A-F would represent the meal on offer and 1-4 would represent the person.

If for example person 1 chooses B, the corresponding cell would be ticked by me under the B column and in the ‘Choice’ column I’d want to return “B”

 ChoiceABCDEF1       2       3       4       

Appreciate any help with this.

Thanks

​I have a fairly simple spreadsheet where a list of names will have made a meal choice from a list which is shown by a ticked checkbox in the corresponding column.  What I would like is to have a list of what each individual person has chosen without having to type it out manually.  Is this possible? Example below –  where A-F would represent the meal on offer and 1-4 would represent the person.If for example person 1 chooses B, the corresponding cell would be ticked by me under the B column and in the ‘Choice’ column I’d want to return “B” ChoiceABCDEF1       2       3       4        Appreciate any help with this. Thanks  Read More

​