I know that Access has this ability in a drop down list but I can't seem to get it in Excel.

Show one word in the drop down list - and input a different word in the cell.

Anyone have any ideas on this one?