Forum Discussion
magzjonez
Oct 24, 2024Copper Contributor
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"
Choice | A | B | C | D | E | F | |
1 | |||||||
2 | |||||||
3 | |||||||
4 |
Appreciate any help with this.
Thanks