+ Reply to Thread
Results 1 to 4 of 4

Prevent dropdown selection in one cell based on dropdown selection in another cell

  1. #1
    Registered User
    Join Date
    09-14-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    82

    Prevent dropdown selection in one cell based on dropdown selection in another cell

    Hi - see the excel file attached. I want to prevent the selection of one dropdown based on the selection of another.
    Attached Files Attached Files

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Prevent dropdown selection in one cell based on dropdown selection in another cell

    Hi,

    You can do this without code. Define a name called ValidDates using this formula
    =INDEX('Background data'!$B$2:$B$13,MATCH(Sheet1!$B$3,'Background data'!$B$2:$B$13,0)+1):'Background data'!$B$13
    and then assign =ValidDates as the validation list for C3.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Prevent dropdown selection in one cell based on dropdown selection in another cell

    deleted by tim
    Last edited by tim201110; 01-19-2017 at 01:49 PM. Reason: misunderstanding

  4. #4
    Registered User
    Join Date
    09-14-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    82

    Re: Prevent dropdown selection in one cell based on dropdown selection in another cell

    @ xlnitwit - great answer - thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Prevent selection of a dropdown option if a different cell is empty
    By pemb3545 in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 12-02-2013, 07:08 AM
  2. Replies: 2
    Last Post: 07-01-2013, 10:51 AM
  3. Changing Cell value based on Dropdown selection
    By src16 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-01-2013, 09:17 AM
  4. Clear cell contents based on offset of dropdown selection on another tab.
    By Drivium in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-22-2013, 10:58 PM
  5. Cull dropdown list options based on selection in another dropdown
    By Kiffar in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-20-2012, 01:53 AM
  6. Update a cell based on selection in dropdown list.
    By ladykickbox in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-26-2012, 07:45 AM
  7. Replies: 3
    Last Post: 09-20-2012, 03:11 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1