+ Reply to Thread
Results 1 to 3 of 3

Formula to check multiple values for multiple specific results

  1. #1
    Registered User
    Join Date
    11-21-2014
    Location
    Fresno, CA
    MS-Off Ver
    2007
    Posts
    5

    Formula to check multiple values for multiple specific results

    Hi There -

    I have a set of data (dates and cells to check if dates match).
    So I have a date from our database (this is a formula), then a cell to check if it matches the next cell, then a date we manually enter.
    The cell that checks if the dates match returns the following values: "OK" - if they match, "UPDATE" - if they do not match, or nothing if they are both blank.

    It's to make sure our notes match what's in our database.


    What I want to do is have a cell at the beginning that will return the value "UPDATE" if ANY of them say "UPDATE".
    If none of them say update AND two specific cells say "OK", I want it to return the value "OK". (I believe this would just be a formula in the false end of an IF formula, but I can't piece together the other parts)
    Otherwise I would like it to be blank.

    I feel like the formula should be pretty similar to the one I have already, but because the cells may have different values in them I can't just do a solid "does this=that".


    Any help on this matter would be greatly appreciated - Thanks!
    -Ashley

  2. #2
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Formula to check multiple values for multiple specific results

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

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

    View Pic
    Quang PT

  3. #3
    Registered User
    Join Date
    11-21-2014
    Location
    Fresno, CA
    MS-Off Ver
    2007
    Posts
    5

    Re: Formula to check multiple values for multiple specific results

    Sorry about that - that would have been helpful.

    Ok, so I highlighted the columns to try and help explain it easier.

    The yellow is where I need help with the formula (I have entered in the desired results for each line).
    Purple columns pull from our database (there is usually a formula there, but I took it out for the example).
    Green we manually enter our dates.
    The blue column is a cell to check one date against the other (those are the columns to look in for the values OK, UPDATE, or if they are blank).

    I think the problem that I'm running into is that those cells have formulas in them, so when I ask it to check if it says "OK" it doesn't see that because it's seeing the formula, maybe? I'm not too sure.

    I hope that helps.
    Attached Files Attached Files

+ 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: 8
    Last Post: 11-06-2014, 06:19 PM
  2. [SOLVED] Formula to check multiple values?! I'm stuck! :(
    By Miss Molko in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-15-2014, 06:54 AM
  3. Find multiple values in multiple ranges and produce results in a list
    By Sc0tt1e in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 02:11 AM
  4. possible to check for file in multiple folders, then check for values in specific cells?
    By mattheritage in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-04-2014, 08:33 AM
  5. Replies: 5
    Last Post: 08-04-2013, 09:49 AM

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