How do I assign a value to an item in a drop-down list i n Excel? I need a
value to an item, such as "weekly", "monthly", etc., that will be used to
calculate other data in other cells.