LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 84
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Two Level Search Jacob Skaria Excel Worksheet Functions 0 May 27th 10 09:29 PM
20 level nested If Hi_no_Tori Excel Discussion (Misc queries) 5 October 11th 07 08:24 AM
workbook level name vs worksheet level name clara Excel Programming 1 September 19th 07 02:32 PM
Using macro to convert single level BOM to Multi Level BOM andrew_chong Excel Programming 0 February 7th 06 08:57 PM
Why, when I create workbook-level name does it jump it to Sheet-level ? Charles Jordan Excel Programming 1 November 5th 03 08:43 PM


All times are GMT +1. The time now is 04:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"