Excel drop-down menu

I have a spreadsheet which has 2 columns containing drop-down lists.  After data validation, one column works perfectly -- the item chosen from the drop-down list populates the cell.  The other colum...