Is there a formula that will allow me to put the data validation arrow in one
cell (that is already populated) and show the selected item from the drop
down list in another cell? Therefore, the original (populated) cell
containing the drop down list remains unchanged.