+ Reply to Thread
Results 1 to 5 of 5

Data Validation with IF Formula + list

  1. #1
    Forum Contributor
    Join Date
    02-09-2015
    Location
    malta
    MS-Off Ver
    Microsoft 365
    Posts
    383

    Data Validation with IF Formula + list

    Hi guys,

    Was wondering whether someone can help me with the below please.

    For ease of reference I have attached a sample work file.

    I have a list of deadlines - as can be seen in the worksheet called 'Information'.

    Next, I have created a data validation list in the sheet called 'Input' whereby on can input any deadlines from the list found in the 'information' tab. Currently one can input an item from this list in Column B.

    Would it be possible to include an IF statement in my data validation, so that the data validation list will only be selectable if in column C there is '1'.

    Thus in the example attached Deadline 3 and Deadline 5 should not have the option to select the deadlines as column C is reading 0, not 1.

    If possible, can someone please assist please?


    Many thanks and appreciate all your kind help !!

    Best regards

    Keibri
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Data Validation with IF Formula + list

    Changing the validation source for B4 to

    =IF(C4=1,Deadlines)

    Will do what you need. Remember to check the box to apply the changes to all cells with the same validation rules before clicking OK.

  3. #3
    Forum Contributor
    Join Date
    02-09-2015
    Location
    malta
    MS-Off Ver
    Microsoft 365
    Posts
    383

    Re: Data Validation with IF Formula + list

    Hi Jason,

    Oh, thanks a lot


    Not sure, would it also be possible to display an "Error Alert" if the value in C is 0, not 1?

    May thanks !

  4. #4
    Forum Expert
    Join Date
    06-08-2012
    Location
    Left the forum!
    MS-Off Ver
    Left the forum!
    Posts
    5,189

    Re: Data Validation with IF Formula + list

    The conventional validation popup messages only work on the cell with the validation, not one that the validation rule is based on.

    The only way to get a popup message would be with a small vba procedure.

    Alternatively, if suitable, you could show the error message as a sole validation list option, by entering the message into a cell with a named range of Error, then using this as the validation formula.

    =IF(C4=1,Deadlines,Error)

  5. #5
    Forum Contributor
    Join Date
    02-09-2015
    Location
    malta
    MS-Off Ver
    Microsoft 365
    Posts
    383

    Re: Data Validation with IF Formula + list

    Thanks a lot Jason much appreciated.

+ 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. Data Validation List - Formula to Sort and Return Unique Values in List
    By beewketu in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-14-2015, 04:18 PM
  2. [SOLVED] Help with Data validation and list with formula
    By compspider in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 07-01-2014, 07:52 AM
  3. Replies: 0
    Last Post: 01-09-2013, 11:44 AM
  4. [SOLVED] Based on data validation list value Formula
    By raw_geek in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-11-2012, 10:12 AM
  5. Replies: 3
    Last Post: 07-20-2012, 09:52 AM
  6. Data Validation List by Formula
    By kborgers in forum Excel General
    Replies: 9
    Last Post: 01-02-2011, 08:57 AM
  7. HELP: Data > Validation ---List ----Formula
    By amit in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2005, 09:06 AM

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