I'm experimenting with trying to create a drop down list so that on selecting a value from one cell in a row, I can pick up the value stored in another cell in the row. The "help" says "select the range of cells and then point to List on the Data menu and click Create List". Problem is "List" does not appear on my Data menu.
(Excel 2002).