+ Reply to Thread
Results 1 to 6 of 6

Need a formula to Pass/Fail data entered based on several variables....

  1. #1
    Registered User
    Join Date
    06-20-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2013
    Posts
    3

    Need a formula to Pass/Fail data entered based on several variables....

    Hi.....I work quality control and would like to see the data "Pass" or "Fail" based upon specification data.

    The worksheet that I enter data has several columns

    Product # / Factory / Weight / Length / Width / Palm Thickness / Finger Thickness

    I would like to add columns next to each that display "Pass" or "Fail" based upon what I measure.

    Another worksheet in this file contains the Factory Specifications. It just lists the different factories in a table with product numbers and what the measurements should be. One product number can have up to four different factories, all with slightly different specifications.

    I wrote a good VLOOKUP formula for a specific variable(i.e. "Length"), but I cannot figure out how to write a formula that will change with varying factories for the same product numbers.

    Any assistance would be hugely appreciated!......this is my first real post....and not too sure if this is very clear.....so please let me know if there is further clarification needed.

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,054

    Re: Need a formula to Pass/Fail data entered based on several variables....

    At least for me, a small sample workbook would help.

    Can you please upload a small representative sample workbook?

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    Last edited by jeffreybrown; 06-20-2013 at 10:00 PM.
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    06-20-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Need a formula to Pass/Fail data entered based on several variables....

    daily measurements for example.xlsm

    Sorry to post under VBA....I thought this subforum was for formulas.

    Would like the formula to populate the "Pass"/"Fail" (or "P"/"F") in column next to entered data.

    Hope the attachment is clear enough....THANK YOU!!!!!!!

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,054

    Re: Need a formula to Pass/Fail data entered based on several variables....

    Let me know if this works for you
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-20-2013
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2013
    Posts
    3

    Re: Need a formula to Pass/Fail data entered based on several variables....

    WOW!!! That's great....works perfectly.

    Greatly appreciated!! Thank you so much!!

  6. #6
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Excel 2016
    Posts
    10,054

    Re: Need a formula to Pass/Fail data entered based on several variables....

    You are very welcome

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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