+ 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
    Office 2010
    Posts
    343

    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
    swindon, england
    MS-Off Ver
    Excel 2016 / Windows 10
    Posts
    3,929

    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
    Office 2010
    Posts
    343

    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
    swindon, england
    MS-Off Ver
    Excel 2016 / Windows 10
    Posts
    3,929

    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
    Office 2010
    Posts
    343

    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)

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