+ Reply to Thread
Results 1 to 4 of 4

Data Validation (custom) formula help

  1. #1
    Registered User
    Join Date
    06-15-2022
    Location
    PA
    MS-Off Ver
    2016
    Posts
    7

    Question Data Validation (custom) formula help

    I have an excel sheet where employees enter part numbers in a column. But I'm running into problems with them misspelling the part numbers. So I made a list on a separate sheet on the same workbook of every part number in our system.
    The goal is to reject every entry that doesn't have a exact match with my list I made.

    Example:

    What they entered (on first sheet)

    631212SVRT-62

    What SHOULDVE been entered

    631212SVRT-628

    And since this number is on my list of numbers, I would like excel to reject it because the number they entered didn't match any number on my list.
    I would prefer to do this on "Data Validation" with a custom formula. I just don't know what formula to use for this.

    Thanks for the help
    Last edited by MisfitJr; 07-28-2023 at 07:16 AM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,520

    Re: Data Validation (custom) formula help

    Hi there,

    Does the attached workbook get you moving in the right direction?

    It uses a Defined Name Range (ptrPartNos) which contains all of the allowable Part Nos, and the Data Validation is set as List, =ptrPartNos


    Hope this helps.

    Regards,

    Greg M
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    06-15-2022
    Location
    PA
    MS-Off Ver
    2016
    Posts
    7

    Re: Data Validation (custom) formula help

    Morning Greg,

    Thanks for this! I set it up in my excel sheet and just took off the drop down list option and it works perfectly.

    Thanks again

  4. #4
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,520

    Re: Data Validation (custom) formula help

    Hi again,

    Many thanks for your feedback.

    You're welcome - glad I was able to help.

    Regards,

    Greg M

+ 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. [SOLVED] Data Validation Custom Formula
    By chezshea in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2019, 03:56 PM
  2. [SOLVED] Need Formula in Data Validation Custom
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2016, 12:45 AM
  3. data validation with custom formula
    By ashveena in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-15-2015, 03:29 PM
  4. [SOLVED] Formula for custom data validation
    By Butcher1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2015, 04:53 PM
  5. [SOLVED] Data Validation Custom Formula
    By dmartinet in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-11-2014, 03:33 PM
  6. [SOLVED] Data Validation Custom Formula
    By turist in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-13-2014, 06:42 AM
  7. Data Validation - Custom - Formula
    By DYeomans in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-02-2005, 01: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