ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
Column B can be hidden
OptionsResultOptionsResult
2
Option AA
=JOIN("",IFERROR(SORT(FILTER(B:B,C:C),1,TRUE)))
ASelected AASelected A
3
Option BBACD
<- What checkboxes are marked
BSelected BABSelected A and B
4
Option CCCSelected CABCSelected A, B, and C
5
Option DD
=XLOOKUP(...,sorted_lookup_table[Options],sorted_lookup_table[Result],"NOT AVAILABLE",-1,2)
DSelected DABCDSelected all
6
Selected A, C, and D
<- Result comes from a lookup in the sorted_lookup_table
If the result does not exists it looks for the previous match (e.g. if ACD was not in the result table, then it
would return "Selected A and C")		ABSelected A and BABDSelected A, B, and D
7
ACSelected A and CACSelected A and C
8
 ^ To only check for exact matches, replace the -1 in the formula for a 0.ADSelected A and DACDSelected A, C, and D
9
BCSelected B and CADSelected A and D
10
BDSelected B and DBSelected B
11
CDSelected C and DBCSelected B and C
12
ABCSelected A, B, and CBCDSelected B, C, and D
13
ABDSelected A, B, and DBDSelected B and D
14
ACDSelected A, C, and DCSelected C
15
BCDSelected B, C, and DCDSelected C and D
16
ABCDSelected allDSelected D
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100