+ Reply to Thread
Results 1 to 3 of 3

Validation List with If statement

  1. #1
    Registered User
    Join Date
    02-24-2011
    Location
    New Hampshire, USA
    MS-Off Ver
    Excel 2007
    Posts
    36

    Question Validation List with If statement

    Hello, I have a validation list in columns E,F,I,L and M (No, Yes, N/A) I would like to put an if statement in columns F-M along with the validation list. So in F3 I would like to enter =if(E3="N/A","N/A"). Basically I would like if E2 = N/A than F2,I2,L2 and M2 are N/A. Any help would be appreciated. Thank you.



    Last edited by snikrs11; 03-04-2011 at 01:25 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Validation List with If statement

    A cell can contain either a constant or a formula, never both simultaneously.

    Data Validation is in essence a constant - as such you can not have a formula in the same cell as the Data Validation.

    If you wish for the constants to default based on prior selections being modified you will need to use VBA I'm afraid (the Change Event - toggling Application.Events as appropriate)
    Last edited by DonkeyOte; 03-04-2011 at 01:28 PM. Reason: typo

  3. #3
    Registered User
    Join Date
    02-24-2011
    Location
    New Hampshire, USA
    MS-Off Ver
    Excel 2007
    Posts
    36

    Re: Validation List with If statement

    Thank you very much. I'm going to try something with conditional formatting.

+ 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