+ Reply to Thread
Results 1 to 3 of 3

Data validation: Restrict cell until another cell has a value, then provide drop down list

  1. #1
    Registered User
    Join Date
    11-22-2013
    Location
    United States
    MS-Off Ver
    Excel 2013
    Posts
    15

    Data validation: Restrict cell until another cell has a value, then provide drop down list

    Hi all,

    I am trying to create a data validation setup that will prevent the user from entering a value in Column A until the corresponding row in Column P has a value. Once this condition is met I would like to allow a selection from a data validation list.

    I was able to find a formula to restrict entry on this forum:

    =AND(P4<>0,P4<>"")

    However I am not certain how to then move to providing for the drop down list. How should I approach this?

    Thanks!

  2. #2
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: Data validation: Restrict cell until another cell has a value, then provide drop down

    Maybe?

    You could use formula's for a reminder in A1, for example. In P1 do your dropdown list. In A1
    =IF(AND(OR(A1=0,A1=""),P1<>""),"PLEASE ENTER A VALUE IN P1 BEFORE CONTINUING","")

  3. #3
    Registered User
    Join Date
    04-28-2017
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    38

    Re: Data validation: Restrict cell until another cell has a value, then provide drop down

    I found that in another post and tried to adapt to your situation. I don't think it's correct.

    The original:

    You could use formula's for a reminder in C1, for example. In B1 do your dropdown list. In C1
    =IF(AND(OR(A1=0,A1=""),B1<>""),"PLEASE ENTER A VALUE IN A1 BEFORE CONTINUING","")


    http://www.excelforum.com/excel-gene...populated.html

+ 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. Replies: 4
    Last Post: 10-13-2014, 09:16 AM
  2. [SOLVED] using a data validation drop down list AND an IF formula in the same cell
    By bite_tony in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 04-16-2014, 03:59 PM
  3. [SOLVED] Data Validation - Restrict cell with multiple conditions
    By hitarov in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 07-11-2013, 03:59 PM
  4. Data Validation,Restrict Cell Input.
    By JapanDave in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-28-2011, 12:56 AM
  5. Replies: 2
    Last Post: 05-12-2011, 09:23 PM
  6. Data Validation: Need to restrict drop-down selection
    By splenguin in forum Excel General
    Replies: 5
    Last Post: 09-08-2009, 03:46 PM
  7. [SOLVED] data validation to restrict input in cell based on value of cell above that cell
    By NC in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-25-2005, 04:06 AM

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