+ Reply to Thread
Results 1 to 7 of 7

Data Validation - If cell contains specific text then error

  1. #1
    Registered User
    Join Date
    11-19-2018
    Location
    Houston
    MS-Off Ver
    1810
    Posts
    58

    Data Validation - If cell contains specific text then error

    Hey guys/gals,

    Im looking to restrict users from continuing to fill our forms without having selected from a drop down first.

    Example:

    If user enters a value in I10 they must select a unit of measurement in J10. I have set data validation on the rest of the form using this formula:

    Please Login or Register  to view this content.
    I also selected "Custom" and "Ignore blank". Problem is, even if I change J10 to anything else the error still pops up. I need it give me an error ONLY IF J10 contains "(UOM)" or if its blank.

    Help please!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Data Validation - If cell contains specific text then error

    When using Custom, you have to use a formula that returns TRUE or FALSE. You used an IF but did not specify the true/false values. This formula is invalid and should not even be accepted as a data validation formula. I get an error when I try to enter that formula.

    Try this:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    This will return FALSE if J10 is (UOM) or blank, causing data validation to reject the entry. It will return TRUE otherwise.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    11-19-2018
    Location
    Houston
    MS-Off Ver
    1810
    Posts
    58

    Re: Data Validation - If cell contains specific text then error

    Just tried it out. I replaced the (UOM) with other text and im still getting an error..

    Used
    Please Login or Register  to view this content.

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Data Validation - If cell contains specific text then error

    This works in my file based on your description. If it does not work in your file, please attach it.

    The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-19-2018
    Location
    Houston
    MS-Off Ver
    1810
    Posts
    58

    Re: Data Validation - If cell contains specific text then error

    Could the fact that J10 already has data validation as a drop down list cause the problem?

  6. #6
    Registered User
    Join Date
    11-19-2018
    Location
    Houston
    MS-Off Ver
    1810
    Posts
    58

    Re: Data Validation - If cell contains specific text then error

    Never mind! Got it to work! Thank you!

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Data Validation - If cell contains specific text then error

    Glad you got it to work, and thanks for the rep. The answer to your question about J10 is no.

    If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."

+ 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: 2
    Last Post: 10-19-2019, 01:11 AM
  2. Replies: 3
    Last Post: 03-30-2019, 12:48 PM
  3. [SOLVED] Data Validation Alert text linked to specific cell
    By Otto Wirke in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 11-27-2018, 10:15 PM
  4. Replies: 7
    Last Post: 10-02-2017, 12:09 PM
  5. Data Validation - Need a date or specific text to be input
    By garethmckeeveraxa in forum Excel General
    Replies: 2
    Last Post: 04-25-2016, 05:54 AM
  6. [SOLVED] Data validation based on another cell containing specific text
    By Sph01 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2013, 05:51 AM
  7. Text Length Data Validation, without error message.
    By mark in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-18-2006, 10:25 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