in 未分类

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

Write a Comment

Comment

2 × 5 =