[Calc] Combox box

LibreOffice (ref)

[Data] -> [Validity ...] -> [Criteria]:

Allow: Cell range

Source:

IF (cell = 一個範圍: 成立的 list, 不成立的 list)

Ex:

IF ($member.$C$2=$cnt.$A$2:$A$24, $cnt.$B$2:$E$24, "")