Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list query
Hi all,
Using MS Excel 2003, I have a table which includes a list of names down in column A, then across the top row is a group of 5 values (0-10,11-20,21-30 etc), the following row then has each of these lists split into 3 further groups within each of the above groups (0-12,13-24,-25-36 - these are for months). The rest of the table is filed with numbers which would be read against which name and group it fitted into. My query is: Is there a way that I can use drop down lists to select each of the outcomes from the table (eg the name, between 11-20 and then 12-24) and then they tell me the value of the cell which the would equal. I would like to know if there is a specific formula which can be used for this. Many thanks in advance. S |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |