Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
If B1=Level 1 then B2=10
Sorry for the double post - but I just realized by Subject line didn't fit at
all!! Cell B1 is using data validation referring to a named range. There are 4 possible values: Level 1, Level 2, Level 3, Level 4. I have another named range with the number of days associated with each Level. So, if the user selects Level 1 from the dropdown list in B1, I want the default number of days (10) to be put automatically into B2. If the user selects Level 2 from the dropdown list in B1, I want the default number of days (20) to be put automatically into B2. And the same for Level 3 (30 days) and Level 4 (40 days). I know there is a way to do this, I think by putting the 2 lists next to each other... but I can't remember how to do it! Help! Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Two Level Search | Excel Worksheet Functions | |||
20 level nested If | Excel Discussion (Misc queries) | |||
workbook level name vs worksheet level name | Excel Programming | |||
Using macro to convert single level BOM to Multi Level BOM | Excel Programming | |||
Why, when I create workbook-level name does it jump it to Sheet-level ? | Excel Programming |