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])