+ Reply to Thread
Results 1 to 8 of 8

Index, Match of If, OR function?2?

  1. #1
    Registered User
    Join Date
    09-29-2018
    Location
    Windsor, ON
    MS-Off Ver
    2016
    Posts
    29

    Index, Match of If, OR function?2?

    Happy New Years to All.


    I have been struggling trying to create a formula to return TEXT based on multiple criteria.

    I have 7 Columns for date inputs: Promise Date., Delivery Date, Cancelled Date, Return Date, Insp Hold Date, Insp Accept Date, Release Date.

    I want them to return text in one column "Delivery Status".

    I had it good until i got greedy.

    I need to have my delivery status based on the last input date so I can make a report and need to keep prior date inputs for tracking reports.

    Please look at my attached file for details.
    Attached Files Attached Files

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2211, rarely 2007
    Posts
    12,822

    Re: Index, Match of If, OR function?2?

    Change the header in E1 to "Pending Date" and this works. In L2 and filled down.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    8,632

    Re: Index, Match of If, OR function?2?

    In L2 then drag down:
    Please Login or Register  to view this content.

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2211, rarely 2007
    Posts
    12,822

    Re: Index, Match of If, OR function?2?

    Yup. Better.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, Suffolk (England), but grew up in Sawley, Derbyshire
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2211 (Windows 11 22H2 64-bit)
    Posts
    65,384

    Re: Index, Match of If, OR function?2?

    StormyGurl - for future reference, your thread title should tell us what it is you are trying to achieve, NOT what you think the solution might be. You now have two threads with almost identical titles, and neither title really tells us anything of any use. Next time you start a thread, please make sure that the title reflects what you are trying to do instead. Thanks!
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  6. #6
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2211, rarely 2007
    Posts
    12,822

    Re: Index, Match of If, OR function?2?

    Ah yes. Based upon your title.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Although I am partial to the LOOKUP function here.

  7. #7
    Registered User
    Join Date
    09-29-2018
    Location
    Windsor, ON
    MS-Off Ver
    2016
    Posts
    29

    Re: Index, Match of If, OR function?2?

    Thank you, All!!!!!

  8. #8
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 Version 2211, rarely 2007
    Posts
    12,822

    Re: Index, Match of If, OR function?2?

    You are welcome. Glad to help. Thank you for the feedback, added rep and marking your thread 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. How to apply an Index.Match.Match function to all entries in a Listbox on a User Form
    By jason.drozd in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 09-25-2018, 01:54 AM
  2. Need help in Index, Match usage to match multiple criteria in sum function
    By Summer0830 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-26-2017, 02:47 AM
  3. Problems applying INDEX-MATCH-MATCH function on other data
    By LennartB in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-13-2015, 05:33 AM
  4. function INDEX MATCH MATCH doesn´t work
    By leonelcd in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-31-2015, 11:36 AM
  5. [SOLVED] Stuck on Match function with #N/A; attempting to reverse Index/Match
    By Cappytano in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-10-2014, 06:39 PM
  6. Replies: 6
    Last Post: 03-17-2014, 08:10 PM
  7. Replies: 3
    Last Post: 06-17-2013, 12:37 PM

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