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.

VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])