| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop down lists
Hi,
I have created a drop down lists with following formula (linked to multiple named rows) so if say cell D17 was 20 then it would return a range of numbers to select in drop down relating to a certain list (twenty.one). =IF(D17="20",twenty.one,IF(D17="22",twentytwo.one, IF(D17="30",thirty.one,IF(D17="40",forty.one)))) This works but I need to add an AND in to the formula and when I try I just get an error. Is it possible to put in an AND in validation? Many thanks. -- Carrie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions | |||
| Drop-down Lists | Excel Worksheet Functions | |||
| drop-down lists | Excel Discussion (Misc queries) | |||
| Drop down lists | Excel Discussion (Misc queries) | |||
| Drop Down Lists | New Users to Excel | |||
Threaded Mode
