Dropdown list and lookup function

[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

 

[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

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.