Dropdown list and lookup function

S

Shakeel

Hello, I am using workbook with 2 sheets, 1 is sheet1, 2 is data sheet, in
sheet 1 I need result from data sheet, in data sheet I have 4 tables call
Quarter (1st Quarter, 2nd, 3rd,4th Quarter) all data related with That
tables, each table have 3 rows and almost 15 columns. I know bit of data
validation and others functions. I try a lot, now I need your help, how to
do it. THANKS
 
A

AnimalMagic

Hello, I am using workbook with 2 sheets, 1 is sheet1, 2 is data sheet, in
sheet 1 I need result from data sheet, in data sheet I have 4 tables call
Quarter (1st Quarter, 2nd, 3rd,4th Quarter) all data related with That
tables, each table have 3 rows and almost 15 columns. I know bit of data
validation and others functions. I try a lot, now I need your help, how to
do it. THANKS
Click to expand...


In the data validation dialog choose "list" as the data source type.

Then, you will be able to input the valid values for the list, and it
will be a drop down list as long as the box remained checked for it.
 
Top