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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need to average data if in cells, but ignore blank cells. 4
Calculation of Quarter 16
Compare identifier columns from 2 sheets - remove rows that are dups 2
remove fill in text from a cell from an unpopulated fill-in cell 1
Still trying to average 4 worksheets and having formula problems 3
Data lookup function 2
Match and delete rows on two different sheets from reference numbers 4
Changing the colour of a range of cells, some with formulas. 8

Top