Excel create drop box and Lookup function Using the data validation dialogue, Setting, Allow -> List, in the source, select the column you want to use as drop box.