Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic lists - IF function does not work!
Hi, I want to have a list (ok with that bit) which is actually dynamic depending on the value in a certain cell. Ie: if you are in department x, the list will only show codes appliacble to deprtament X, whereas if you enter department Y - a different list appears. I know how to do the lists and look ups but it is the dynamic lists bit that I am stuck with. Does anyone have any idea? -- Emea training ------------------------------------------------------------------------ Emea training's Profile: http://www.excelforum.com/member.php...o&userid=12064 View this thread: http://www.excelforum.com/showthread...hreadid=558470 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic lists - IF function does not work!
You may be able to use data|validation and dependent lists.
Debra Dalgleish knows how: http://contextures.com/xlDataVal02.html Emea training wrote: Hi, I want to have a list (ok with that bit) which is actually dynamic depending on the value in a certain cell. Ie: if you are in department x, the list will only show codes appliacble to deprtament X, whereas if you enter department Y - a different list appears. I know how to do the lists and look ups but it is the dynamic lists bit that I am stuck with. Does anyone have any idea? -- Emea training ------------------------------------------------------------------------ Emea training's Profile: http://www.excelforum.com/member.php...o&userid=12064 View this thread: http://www.excelforum.com/showthread...hreadid=558470 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Does excel have a 'cubed root' function? How can it work it out? | Excel Worksheet Functions | |||
Dynamic Range for Function (Vlookup etc) | Excel Worksheet Functions |