Forum Discussion

magzjonez's avatar
magzjonez
Copper Contributor
Oct 24, 2024

Is there a formula that can populate a cell with a column header text if a checkbox is ticked?

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"

 ChoiceABCDEF
1       
2       
3       
4       

 

Appreciate any help with this.

 

Thanks

    • magzjonez's avatar
      magzjonez
      Copper Contributor
      Thank you so much, worked a treat 🙂

Resources