+ Reply to Thread
Results 1 to 5 of 5

Data Validation from one column locking another column until condition is met

  1. #1
    Registered User
    Join Date
    07-10-2017
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    2013
    Posts
    3

    Data Validation from one column locking another column until condition is met

    Hello,

    I am brand new to the forum so bare with me on explaining this. I hope this is clear.

    I am fairly efficient in excel/google sheets but I cannot get this right and I hope you guys can help.

    I have 3 total columns that I am working with Columns I, J and K

    Column I has a dropdown list with 4 options
    Gradebook
    Load
    Delete - Core
    Delete- Elective

    Column J only available if they pick Delete - Core or Delete - Elective from Column I

    Column K is also conditional per Column I but I want these to autopopulate based on what is selected in Column I

    Gradebook = Setup
    Load = Setup
    Delete- Core = Load New Curriculum
    Delete - Elective = Delete Course


    Sorry if this is confusing if you have questions please don't hesitate, I may be overthinking this but this is beyond my abilities.

    Thank you in advance for your assistance.

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Data Validation from one column locking another column until condition is met

    Assuming data starts in row 2
    Selecting J2:J? > Data Validation>Custom> =IF(LEFT(I2,6)="Delete", LEN(J2)>0)

    For K2 copied down, this formula
    =IF(OR(I2={"Gradebook", "Load"}), "Setup", If(I2="Delete - Core", "Load New Curriculum", If(I2="Delete - Elective", "Delete Course", ""))))

    Or you could set up a little VLOOKUP table for your K formula and
    =IFERROR(VLOOKUP(I2, Mytable,2,FALSE),"")
    Does that help?
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    07-10-2017
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    2013
    Posts
    3

    Re: Data Validation from one column locking another column until condition is met

    Code for Column I will save however it doesn't load anything into Column K once an option in Column I is selected.

    I didn't state clearly for Column J earlier and that's my fault that it should be allowed to accept any text put in. So it is locked until one of the option in Column I has been selected.

  4. #4
    Registered User
    Join Date
    07-10-2017
    Location
    Oklahoma City, Oklahoma
    MS-Off Ver
    2013
    Posts
    3

    Re: Data Validation from one column locking another column until condition is met

    The initial code got me on the right track. Thank you for the input.

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Data Validation from one column locking another column until condition is met

    I am attaching the file which works the way I think you want the worksheet to work. Let me know what it is doing (or not doing) that you want it to do.
    I protected the worksheet (no password) so that the user cannot modify column K manually.
    Attached Files Attached Files

+ 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. Creating validation list from table column based on data in another column
    By dreamthrum in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-11-2013, 08:38 PM
  2. Prevent copying and pasting a cell from a column with data validation to another column
    By kieranoduill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2013, 10:02 AM
  3. Replies: 3
    Last Post: 01-23-2012, 11:04 AM
  4. Replies: 2
    Last Post: 09-03-2011, 04:31 AM
  5. Replies: 6
    Last Post: 11-28-2010, 07:52 PM
  6. Locking column entries to an adjacent linked column
    By Steeljaw in forum Excel General
    Replies: 1
    Last Post: 01-23-2006, 06:50 PM
  7. Replies: 3
    Last Post: 08-17-2005, 05:32 PM

Tags for this Thread

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