I am trying to have a drop box on a cell, so I can insert several names and
pick up whichever one I want

e.g
A. PRO-KING
B. PRO-QUEEN
C. ALISTAIR
D. NORMAN
E. ETC

I NEED ALL THIS TO SHOW IN A CELL AND I WILL NOW PICK THE ONE I NEED INSTEAD
OF HAVING TO TYPE THEM OVER AND OVER AGAIN.

ANY HELP, PLEASE